{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "请输入股票名：\n",
      "Empty DataFrame\n",
      "Columns: [日期, 股票代码, 名称, 收盘价, 最高价, 最低价, 开盘价, 前收盘, 涨跌额, 涨跌幅, 换手率, 成交量, 成交金额, 总市值, 流通市值]\n",
      "Index: []\n"
     ]
    }
   ],
   "source": [
    "file_flag = input(\"请输入股票名：\")\n",
    "if file_flag == '1' or True:\n",
    "    csv_file = r'/home/cpj/python/data/lab2/data/600519.csv'\n",
    "\n",
    "    csv = pd.read_csv(csv_file, encoding='gb18030')\n",
    "\n",
    "    df = pd.DataFrame(csv)\n",
    "    date =  '2020-09-17'\n",
    "    test1 = df[df['日期']==date_]\n",
    "    print(test1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "请输入股票名：\n",
      "1\n",
      "输入日期\n",
      "2020-09-17\n",
      "\n",
      "           日期     股票代码    名称      收盘价     最高价     最低价     开盘价     前收盘     涨跌额  \\\n",
      "2  2020-09-17  '600519  贵州茅台  1670.52  1700.0  1658.0  1700.0  1725.1  -54.58   \n",
      "\n",
      "       涨跌幅     换手率      成交量          成交金额           总市值          流通市值  \n",
      "2  -3.1639  0.5069  6367985  1.068335e+10  2.098504e+12  2.098504e+12  \n"
     ]
    }
   ],
   "source": [
    "file_flag = input(\"请输入股票名：\")\n",
    "if file_flag == '1' or True:\n",
    "    csv_file = r'/home/cpj/python/data/lab2/data/600519.csv'\n",
    "\n",
    "    csv = pd.read_csv(csv_file, encoding='gb18030')\n",
    "\n",
    "    df = pd.DataFrame(csv)\n",
    "    date =  input(\"输入日期\")\n",
    "    test1 = df[df['日期']==date_]\n",
    "    print(test1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "请输入股票名：\n",
      "1\n",
      "输入日期\n",
      "2020-09-17\n",
      "\n",
      "           日期     股票代码    名称      收盘价     最高价     最低价     开盘价     前收盘     涨跌额  \\\n",
      "2  2020-09-17  '600519  贵州茅台  1670.52  1700.0  1658.0  1700.0  1725.1  -54.58   \n",
      "\n",
      "       涨跌幅     换手率      成交量          成交金额           总市值          流通市值  \n",
      "2  -3.1639  0.5069  6367985  1.068335e+10  2.098504e+12  2.098504e+12  \n"
     ]
    }
   ],
   "source": [
    "print('请输入股票名：\\n1\\n输入日期\\n2020-09-17\\n')\n",
    "print(df[df['日期']=='2020-09-17'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1800\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>日期</th>\n",
       "      <th>股票代码</th>\n",
       "      <th>名称</th>\n",
       "      <th>收盘价</th>\n",
       "      <th>最高价</th>\n",
       "      <th>最低价</th>\n",
       "      <th>开盘价</th>\n",
       "      <th>前收盘</th>\n",
       "      <th>涨跌额</th>\n",
       "      <th>涨跌幅</th>\n",
       "      <th>换手率</th>\n",
       "      <th>成交量</th>\n",
       "      <th>成交金额</th>\n",
       "      <th>总市值</th>\n",
       "      <th>流通市值</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2020-09-01</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>1801.98</td>\n",
       "      <td>1802.0</td>\n",
       "      <td>1775.01</td>\n",
       "      <td>1792.0</td>\n",
       "      <td>1786.5</td>\n",
       "      <td>15.48</td>\n",
       "      <td>0.8665</td>\n",
       "      <td>0.2519</td>\n",
       "      <td>3163992</td>\n",
       "      <td>5.661594e+09</td>\n",
       "      <td>2.263643e+12</td>\n",
       "      <td>2.263643e+12</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            日期     股票代码    名称      收盘价     最高价      最低价     开盘价     前收盘  \\\n",
       "14  2020-09-01  '600519  贵州茅台  1801.98  1802.0  1775.01  1792.0  1786.5   \n",
       "\n",
       "      涨跌额     涨跌幅     换手率      成交量          成交金额           总市值          流通市值  \n",
       "14  15.48  0.8665  0.2519  3163992  5.661594e+09  2.263643e+12  2.263643e+12  "
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "flag = (float)(input())\n",
    "df[df['收盘价']>flag]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "9\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>日期</th>\n",
       "      <th>股票代码</th>\n",
       "      <th>名称</th>\n",
       "      <th>收盘价</th>\n",
       "      <th>最高价</th>\n",
       "      <th>最低价</th>\n",
       "      <th>开盘价</th>\n",
       "      <th>前收盘</th>\n",
       "      <th>涨跌额</th>\n",
       "      <th>涨跌幅</th>\n",
       "      <th>换手率</th>\n",
       "      <th>成交量</th>\n",
       "      <th>成交金额</th>\n",
       "      <th>总市值</th>\n",
       "      <th>流通市值</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1324</th>\n",
       "      <td>2015-04-21</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>257.43</td>\n",
       "      <td>257.43</td>\n",
       "      <td>240.0</td>\n",
       "      <td>240.0</td>\n",
       "      <td>234.03</td>\n",
       "      <td>23.4</td>\n",
       "      <td>9.9987</td>\n",
       "      <td>1.0718</td>\n",
       "      <td>12240188</td>\n",
       "      <td>3.039244e+09</td>\n",
       "      <td>2.939845e+11</td>\n",
       "      <td>2.939845e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1893</th>\n",
       "      <td>2012-12-10</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>198.79</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>2.063798e+11</td>\n",
       "      <td>2.063798e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1958</th>\n",
       "      <td>2012-09-03</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>219.76</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>2.281504e+11</td>\n",
       "      <td>2.281504e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2026</th>\n",
       "      <td>2012-05-29</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>225.49</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>2.340992e+11</td>\n",
       "      <td>2.340992e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2271</th>\n",
       "      <td>2011-05-25</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>194.61</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1.836729e+11</td>\n",
       "      <td>1.836729e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4067</th>\n",
       "      <td>2003-12-29</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25.28</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>7.647200e+09</td>\n",
       "      <td>2.187099e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4204</th>\n",
       "      <td>2003-06-12</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25.61</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>7.042750e+09</td>\n",
       "      <td>2.014226e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4328</th>\n",
       "      <td>2002-11-29</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>26.28</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>7.227000e+09</td>\n",
       "      <td>2.066922e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4435</th>\n",
       "      <td>2002-06-25</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>38.18</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>9.545000e+09</td>\n",
       "      <td>2.729870e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4516</th>\n",
       "      <td>2002-02-25</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>37.65</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>9.412500e+09</td>\n",
       "      <td>2.691975e+09</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>83 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              日期     股票代码    名称     收盘价     最高价    最低价    开盘价     前收盘   涨跌额  \\\n",
       "1324  2015-04-21  '600519  贵州茅台  257.43  257.43  240.0  240.0  234.03  23.4   \n",
       "1893  2012-12-10  '600519  贵州茅台    0.00    0.00    0.0    0.0  198.79  None   \n",
       "1958  2012-09-03  '600519  贵州茅台    0.00    0.00    0.0    0.0  219.76  None   \n",
       "2026  2012-05-29  '600519  贵州茅台    0.00    0.00    0.0    0.0  225.49  None   \n",
       "2271  2011-05-25  '600519  贵州茅台    0.00    0.00    0.0    0.0  194.61  None   \n",
       "...          ...      ...   ...     ...     ...    ...    ...     ...   ...   \n",
       "4067  2003-12-29  '600519  贵州茅台    0.00    0.00    0.0    0.0   25.28  None   \n",
       "4204  2003-06-12  '600519  贵州茅台    0.00    0.00    0.0    0.0   25.61  None   \n",
       "4328  2002-11-29  '600519  贵州茅台    0.00    0.00    0.0    0.0   26.28  None   \n",
       "4435  2002-06-25  '600519  贵州茅台    0.00    0.00    0.0    0.0   38.18  None   \n",
       "4516  2002-02-25  '600519  贵州茅台    0.00    0.00    0.0    0.0   37.65  None   \n",
       "\n",
       "         涨跌幅     换手率       成交量          成交金额           总市值          流通市值  \n",
       "1324  9.9987  1.0718  12240188  3.039244e+09  2.939845e+11  2.939845e+11  \n",
       "1893    None  0.0000         0  0.000000e+00  2.063798e+11  2.063798e+11  \n",
       "1958    None  0.0000         0  0.000000e+00  2.281504e+11  2.281504e+11  \n",
       "2026    None  0.0000         0  0.000000e+00  2.340992e+11  2.340992e+11  \n",
       "2271    None  0.0000         0  0.000000e+00  1.836729e+11  1.836729e+11  \n",
       "...      ...     ...       ...           ...           ...           ...  \n",
       "4067    None  0.0000         0  0.000000e+00  7.647200e+09  2.187099e+09  \n",
       "4204    None  0.0000         0  0.000000e+00  7.042750e+09  2.014226e+09  \n",
       "4328    None  0.0000         0  0.000000e+00  7.227000e+09  2.066922e+09  \n",
       "4435    None  0.0000         0  0.000000e+00  9.545000e+09  2.729870e+09  \n",
       "4516    None  0.0000         0  0.000000e+00  9.412500e+09  2.691975e+09  \n",
       "\n",
       "[83 rows x 15 columns]"
      ]
     },
     "execution_count": 69,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "flag = input()\n",
    "df[df['涨跌幅']>flag]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "12222222\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>日期</th>\n",
       "      <th>股票代码</th>\n",
       "      <th>名称</th>\n",
       "      <th>收盘价</th>\n",
       "      <th>最高价</th>\n",
       "      <th>最低价</th>\n",
       "      <th>开盘价</th>\n",
       "      <th>前收盘</th>\n",
       "      <th>涨跌额</th>\n",
       "      <th>涨跌幅</th>\n",
       "      <th>换手率</th>\n",
       "      <th>成交量</th>\n",
       "      <th>成交金额</th>\n",
       "      <th>总市值</th>\n",
       "      <th>流通市值</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>2020-02-03</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>1003.92</td>\n",
       "      <td>1010.68</td>\n",
       "      <td>980.00</td>\n",
       "      <td>985.00</td>\n",
       "      <td>1052.80</td>\n",
       "      <td>-48.88</td>\n",
       "      <td>-4.6429</td>\n",
       "      <td>0.9827</td>\n",
       "      <td>12344288</td>\n",
       "      <td>1.231499e+10</td>\n",
       "      <td>1.261122e+12</td>\n",
       "      <td>1.261122e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>174</th>\n",
       "      <td>2020-01-03</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>1078.56</td>\n",
       "      <td>1117.00</td>\n",
       "      <td>1076.90</td>\n",
       "      <td>1117.00</td>\n",
       "      <td>1130.00</td>\n",
       "      <td>-51.44</td>\n",
       "      <td>-4.5522</td>\n",
       "      <td>1.0374</td>\n",
       "      <td>13031878</td>\n",
       "      <td>1.426638e+10</td>\n",
       "      <td>1.354885e+12</td>\n",
       "      <td>1.354885e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>2020-01-02</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>1130.00</td>\n",
       "      <td>1145.06</td>\n",
       "      <td>1116.00</td>\n",
       "      <td>1128.00</td>\n",
       "      <td>1183.00</td>\n",
       "      <td>-53.0</td>\n",
       "      <td>-4.4801</td>\n",
       "      <td>1.1789</td>\n",
       "      <td>14809916</td>\n",
       "      <td>1.669684e+10</td>\n",
       "      <td>1.419504e+12</td>\n",
       "      <td>1.419504e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>340</th>\n",
       "      <td>2019-05-06</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>906.00</td>\n",
       "      <td>935.00</td>\n",
       "      <td>893.00</td>\n",
       "      <td>925.50</td>\n",
       "      <td>974.00</td>\n",
       "      <td>-68.0</td>\n",
       "      <td>-6.9815</td>\n",
       "      <td>1.0755</td>\n",
       "      <td>13509968</td>\n",
       "      <td>1.229940e+10</td>\n",
       "      <td>1.138115e+12</td>\n",
       "      <td>1.138115e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>463</th>\n",
       "      <td>2018-10-30</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>524.00</td>\n",
       "      <td>543.00</td>\n",
       "      <td>509.02</td>\n",
       "      <td>510.00</td>\n",
       "      <td>549.09</td>\n",
       "      <td>-25.09</td>\n",
       "      <td>-4.5694</td>\n",
       "      <td>1.6271</td>\n",
       "      <td>20439667</td>\n",
       "      <td>1.066339e+10</td>\n",
       "      <td>6.582476e+11</td>\n",
       "      <td>6.582476e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>468</th>\n",
       "      <td>2018-10-23</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>641.74</td>\n",
       "      <td>689.00</td>\n",
       "      <td>635.00</td>\n",
       "      <td>689.00</td>\n",
       "      <td>693.00</td>\n",
       "      <td>-51.26</td>\n",
       "      <td>-7.3968</td>\n",
       "      <td>0.9800</td>\n",
       "      <td>12311273</td>\n",
       "      <td>8.076619e+09</td>\n",
       "      <td>8.061524e+11</td>\n",
       "      <td>8.061524e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>664</th>\n",
       "      <td>2017-12-28</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>718.69</td>\n",
       "      <td>719.90</td>\n",
       "      <td>671.32</td>\n",
       "      <td>687.00</td>\n",
       "      <td>664.18</td>\n",
       "      <td>54.51</td>\n",
       "      <td>8.2071</td>\n",
       "      <td>0.9882</td>\n",
       "      <td>12414107</td>\n",
       "      <td>8.656876e+09</td>\n",
       "      <td>9.028168e+11</td>\n",
       "      <td>9.028168e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>690</th>\n",
       "      <td>2017-11-22</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>650.52</td>\n",
       "      <td>688.00</td>\n",
       "      <td>650.00</td>\n",
       "      <td>677.00</td>\n",
       "      <td>677.25</td>\n",
       "      <td>-26.73</td>\n",
       "      <td>-3.9468</td>\n",
       "      <td>1.0229</td>\n",
       "      <td>12849826</td>\n",
       "      <td>8.528143e+09</td>\n",
       "      <td>8.171818e+11</td>\n",
       "      <td>8.171818e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>693</th>\n",
       "      <td>2017-11-17</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>690.25</td>\n",
       "      <td>709.00</td>\n",
       "      <td>677.77</td>\n",
       "      <td>696.00</td>\n",
       "      <td>719.11</td>\n",
       "      <td>-28.86</td>\n",
       "      <td>-4.0133</td>\n",
       "      <td>0.9860</td>\n",
       "      <td>12386124</td>\n",
       "      <td>8.548748e+09</td>\n",
       "      <td>8.670905e+11</td>\n",
       "      <td>8.670905e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1236</th>\n",
       "      <td>2015-08-25</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>176.59</td>\n",
       "      <td>182.51</td>\n",
       "      <td>166.20</td>\n",
       "      <td>167.46</td>\n",
       "      <td>169.64</td>\n",
       "      <td>6.95</td>\n",
       "      <td>4.0969</td>\n",
       "      <td>0.9798</td>\n",
       "      <td>12308058</td>\n",
       "      <td>2.165824e+09</td>\n",
       "      <td>2.218320e+11</td>\n",
       "      <td>2.218320e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1267</th>\n",
       "      <td>2015-07-13</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>257.75</td>\n",
       "      <td>265.58</td>\n",
       "      <td>251.00</td>\n",
       "      <td>258.00</td>\n",
       "      <td>265.59</td>\n",
       "      <td>-7.84</td>\n",
       "      <td>-2.9519</td>\n",
       "      <td>1.3041</td>\n",
       "      <td>14892616</td>\n",
       "      <td>3.838169e+09</td>\n",
       "      <td>2.943500e+11</td>\n",
       "      <td>2.943500e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1268</th>\n",
       "      <td>2015-07-10</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>265.59</td>\n",
       "      <td>283.00</td>\n",
       "      <td>251.96</td>\n",
       "      <td>257.00</td>\n",
       "      <td>257.94</td>\n",
       "      <td>7.65</td>\n",
       "      <td>2.9658</td>\n",
       "      <td>2.2430</td>\n",
       "      <td>25614930</td>\n",
       "      <td>6.888908e+09</td>\n",
       "      <td>3.033032e+11</td>\n",
       "      <td>3.033032e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1269</th>\n",
       "      <td>2015-07-09</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>257.94</td>\n",
       "      <td>260.41</td>\n",
       "      <td>233.00</td>\n",
       "      <td>236.86</td>\n",
       "      <td>236.86</td>\n",
       "      <td>21.08</td>\n",
       "      <td>8.8998</td>\n",
       "      <td>1.2102</td>\n",
       "      <td>13820334</td>\n",
       "      <td>3.409951e+09</td>\n",
       "      <td>2.945670e+11</td>\n",
       "      <td>2.945670e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1270</th>\n",
       "      <td>2015-07-08</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>236.86</td>\n",
       "      <td>244.99</td>\n",
       "      <td>219.76</td>\n",
       "      <td>229.00</td>\n",
       "      <td>244.18</td>\n",
       "      <td>-7.32</td>\n",
       "      <td>-2.9978</td>\n",
       "      <td>2.5319</td>\n",
       "      <td>28914054</td>\n",
       "      <td>6.738027e+09</td>\n",
       "      <td>2.704936e+11</td>\n",
       "      <td>2.704936e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1271</th>\n",
       "      <td>2015-07-07</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>244.18</td>\n",
       "      <td>256.58</td>\n",
       "      <td>239.50</td>\n",
       "      <td>250.00</td>\n",
       "      <td>254.04</td>\n",
       "      <td>-9.86</td>\n",
       "      <td>-3.8813</td>\n",
       "      <td>1.4673</td>\n",
       "      <td>16756224</td>\n",
       "      <td>4.121732e+09</td>\n",
       "      <td>2.788531e+11</td>\n",
       "      <td>2.788531e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1272</th>\n",
       "      <td>2015-07-06</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>254.04</td>\n",
       "      <td>267.99</td>\n",
       "      <td>239.50</td>\n",
       "      <td>267.95</td>\n",
       "      <td>249.81</td>\n",
       "      <td>4.23</td>\n",
       "      <td>1.6933</td>\n",
       "      <td>2.3888</td>\n",
       "      <td>27279966</td>\n",
       "      <td>7.012491e+09</td>\n",
       "      <td>2.901132e+11</td>\n",
       "      <td>2.901132e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1276</th>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>257.65</td>\n",
       "      <td>259.82</td>\n",
       "      <td>246.00</td>\n",
       "      <td>246.64</td>\n",
       "      <td>246.64</td>\n",
       "      <td>11.01</td>\n",
       "      <td>4.464</td>\n",
       "      <td>1.1059</td>\n",
       "      <td>12629819</td>\n",
       "      <td>3.205286e+09</td>\n",
       "      <td>2.942358e+11</td>\n",
       "      <td>2.942358e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1277</th>\n",
       "      <td>2015-06-29</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>246.64</td>\n",
       "      <td>256.50</td>\n",
       "      <td>227.80</td>\n",
       "      <td>248.37</td>\n",
       "      <td>242.45</td>\n",
       "      <td>4.19</td>\n",
       "      <td>1.7282</td>\n",
       "      <td>1.4455</td>\n",
       "      <td>16507167</td>\n",
       "      <td>4.057070e+09</td>\n",
       "      <td>2.816624e+11</td>\n",
       "      <td>2.816624e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1323</th>\n",
       "      <td>2015-04-22</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>263.89</td>\n",
       "      <td>269.00</td>\n",
       "      <td>257.11</td>\n",
       "      <td>268.80</td>\n",
       "      <td>257.43</td>\n",
       "      <td>6.46</td>\n",
       "      <td>2.5094</td>\n",
       "      <td>1.1789</td>\n",
       "      <td>13463506</td>\n",
       "      <td>3.543577e+09</td>\n",
       "      <td>3.013619e+11</td>\n",
       "      <td>3.013619e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1324</th>\n",
       "      <td>2015-04-21</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>257.43</td>\n",
       "      <td>257.43</td>\n",
       "      <td>240.00</td>\n",
       "      <td>240.00</td>\n",
       "      <td>234.03</td>\n",
       "      <td>23.4</td>\n",
       "      <td>9.9987</td>\n",
       "      <td>1.0718</td>\n",
       "      <td>12240188</td>\n",
       "      <td>3.039244e+09</td>\n",
       "      <td>2.939845e+11</td>\n",
       "      <td>2.939845e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1325</th>\n",
       "      <td>2015-04-20</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>234.03</td>\n",
       "      <td>245.70</td>\n",
       "      <td>229.00</td>\n",
       "      <td>230.00</td>\n",
       "      <td>232.56</td>\n",
       "      <td>1.47</td>\n",
       "      <td>0.6321</td>\n",
       "      <td>1.1435</td>\n",
       "      <td>13058871</td>\n",
       "      <td>3.118765e+09</td>\n",
       "      <td>2.672618e+11</td>\n",
       "      <td>2.672618e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1326</th>\n",
       "      <td>2015-04-17</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>232.56</td>\n",
       "      <td>248.70</td>\n",
       "      <td>228.28</td>\n",
       "      <td>238.90</td>\n",
       "      <td>226.27</td>\n",
       "      <td>6.29</td>\n",
       "      <td>2.7799</td>\n",
       "      <td>1.6821</td>\n",
       "      <td>19209491</td>\n",
       "      <td>4.577504e+09</td>\n",
       "      <td>2.655831e+11</td>\n",
       "      <td>2.655831e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1333</th>\n",
       "      <td>2015-04-08</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>204.50</td>\n",
       "      <td>210.68</td>\n",
       "      <td>201.59</td>\n",
       "      <td>202.50</td>\n",
       "      <td>200.67</td>\n",
       "      <td>3.83</td>\n",
       "      <td>1.9086</td>\n",
       "      <td>1.1896</td>\n",
       "      <td>13585716</td>\n",
       "      <td>2.798382e+09</td>\n",
       "      <td>2.335386e+11</td>\n",
       "      <td>2.335386e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1411</th>\n",
       "      <td>2014-12-09</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>172.86</td>\n",
       "      <td>186.62</td>\n",
       "      <td>171.50</td>\n",
       "      <td>172.00</td>\n",
       "      <td>172.97</td>\n",
       "      <td>-0.11</td>\n",
       "      <td>-0.0636</td>\n",
       "      <td>1.3300</td>\n",
       "      <td>15189028</td>\n",
       "      <td>2.713372e+09</td>\n",
       "      <td>1.974058e+11</td>\n",
       "      <td>1.974058e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1427</th>\n",
       "      <td>2014-11-17</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>160.05</td>\n",
       "      <td>168.00</td>\n",
       "      <td>160.00</td>\n",
       "      <td>168.00</td>\n",
       "      <td>157.29</td>\n",
       "      <td>2.76</td>\n",
       "      <td>1.7547</td>\n",
       "      <td>1.3171</td>\n",
       "      <td>15041623</td>\n",
       "      <td>2.451674e+09</td>\n",
       "      <td>1.827768e+11</td>\n",
       "      <td>1.827768e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1718</th>\n",
       "      <td>2013-09-03</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>151.66</td>\n",
       "      <td>152.80</td>\n",
       "      <td>149.00</td>\n",
       "      <td>151.00</td>\n",
       "      <td>151.92</td>\n",
       "      <td>-0.26</td>\n",
       "      <td>-0.1711</td>\n",
       "      <td>1.1868</td>\n",
       "      <td>12321105</td>\n",
       "      <td>1.855979e+09</td>\n",
       "      <td>1.574504e+11</td>\n",
       "      <td>1.574504e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1719</th>\n",
       "      <td>2013-09-02</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>151.92</td>\n",
       "      <td>160.80</td>\n",
       "      <td>151.90</td>\n",
       "      <td>160.80</td>\n",
       "      <td>168.78</td>\n",
       "      <td>-16.86</td>\n",
       "      <td>-9.9893</td>\n",
       "      <td>2.1670</td>\n",
       "      <td>22497074</td>\n",
       "      <td>3.438419e+09</td>\n",
       "      <td>1.577203e+11</td>\n",
       "      <td>1.577203e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1861</th>\n",
       "      <td>2013-01-28</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>178.50</td>\n",
       "      <td>187.80</td>\n",
       "      <td>178.00</td>\n",
       "      <td>186.00</td>\n",
       "      <td>189.05</td>\n",
       "      <td>-10.55</td>\n",
       "      <td>-5.5805</td>\n",
       "      <td>1.5247</td>\n",
       "      <td>15829058</td>\n",
       "      <td>2.857093e+09</td>\n",
       "      <td>1.853151e+11</td>\n",
       "      <td>1.853151e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2400</th>\n",
       "      <td>2010-11-12</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>177.53</td>\n",
       "      <td>188.08</td>\n",
       "      <td>175.52</td>\n",
       "      <td>175.55</td>\n",
       "      <td>175.92</td>\n",
       "      <td>1.61</td>\n",
       "      <td>0.9152</td>\n",
       "      <td>1.3403</td>\n",
       "      <td>12650029</td>\n",
       "      <td>2.298576e+09</td>\n",
       "      <td>1.675528e+11</td>\n",
       "      <td>1.675528e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2402</th>\n",
       "      <td>2010-11-10</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>179.73</td>\n",
       "      <td>182.45</td>\n",
       "      <td>166.50</td>\n",
       "      <td>166.60</td>\n",
       "      <td>165.86</td>\n",
       "      <td>13.87</td>\n",
       "      <td>8.3625</td>\n",
       "      <td>1.5894</td>\n",
       "      <td>15000509</td>\n",
       "      <td>2.670067e+09</td>\n",
       "      <td>1.696292e+11</td>\n",
       "      <td>1.696292e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2547</th>\n",
       "      <td>2010-04-02</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>152.63</td>\n",
       "      <td>158.00</td>\n",
       "      <td>151.60</td>\n",
       "      <td>158.00</td>\n",
       "      <td>160.06</td>\n",
       "      <td>-7.43</td>\n",
       "      <td>-4.642</td>\n",
       "      <td>1.6347</td>\n",
       "      <td>15428170</td>\n",
       "      <td>2.359759e+09</td>\n",
       "      <td>1.440522e+11</td>\n",
       "      <td>1.440522e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3256</th>\n",
       "      <td>2007-05-14</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>94.39</td>\n",
       "      <td>100.78</td>\n",
       "      <td>92.18</td>\n",
       "      <td>93.60</td>\n",
       "      <td>92.00</td>\n",
       "      <td>2.39</td>\n",
       "      <td>2.5978</td>\n",
       "      <td>4.3620</td>\n",
       "      <td>13187045</td>\n",
       "      <td>1.263779e+09</td>\n",
       "      <td>8.908528e+10</td>\n",
       "      <td>2.853580e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3259</th>\n",
       "      <td>2007-05-09</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>92.00</td>\n",
       "      <td>96.51</td>\n",
       "      <td>89.90</td>\n",
       "      <td>96.50</td>\n",
       "      <td>96.50</td>\n",
       "      <td>-4.5</td>\n",
       "      <td>-4.6632</td>\n",
       "      <td>5.0204</td>\n",
       "      <td>15177660</td>\n",
       "      <td>1.394029e+09</td>\n",
       "      <td>8.682960e+10</td>\n",
       "      <td>2.781326e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3486</th>\n",
       "      <td>2006-05-31</td>\n",
       "      <td>'600519</td>\n",
       "      <td>G 茅  台</td>\n",
       "      <td>48.02</td>\n",
       "      <td>51.90</td>\n",
       "      <td>46.88</td>\n",
       "      <td>48.45</td>\n",
       "      <td>48.39</td>\n",
       "      <td>-0.37</td>\n",
       "      <td>-0.7646</td>\n",
       "      <td>5.0189</td>\n",
       "      <td>15173103</td>\n",
       "      <td>7.474115e+08</td>\n",
       "      <td>4.532128e+10</td>\n",
       "      <td>1.451731e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3487</th>\n",
       "      <td>2006-05-30</td>\n",
       "      <td>'600519</td>\n",
       "      <td>G 茅  台</td>\n",
       "      <td>48.39</td>\n",
       "      <td>48.39</td>\n",
       "      <td>45.61</td>\n",
       "      <td>47.10</td>\n",
       "      <td>43.99</td>\n",
       "      <td>4.4</td>\n",
       "      <td>10.0023</td>\n",
       "      <td>4.5898</td>\n",
       "      <td>13875854</td>\n",
       "      <td>6.647766e+08</td>\n",
       "      <td>4.567048e+10</td>\n",
       "      <td>1.462917e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3490</th>\n",
       "      <td>2006-05-25</td>\n",
       "      <td>'600519</td>\n",
       "      <td>G 茅  台</td>\n",
       "      <td>39.59</td>\n",
       "      <td>47.00</td>\n",
       "      <td>38.10</td>\n",
       "      <td>45.00</td>\n",
       "      <td>44.97</td>\n",
       "      <td>-5.38</td>\n",
       "      <td>-11.9635</td>\n",
       "      <td>6.5533</td>\n",
       "      <td>19811697</td>\n",
       "      <td>8.119087e+08</td>\n",
       "      <td>3.736504e+10</td>\n",
       "      <td>1.196877e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4627</th>\n",
       "      <td>2001-08-28</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>36.86</td>\n",
       "      <td>37.00</td>\n",
       "      <td>34.61</td>\n",
       "      <td>34.99</td>\n",
       "      <td>35.55</td>\n",
       "      <td>1.31</td>\n",
       "      <td>3.685</td>\n",
       "      <td>18.1326</td>\n",
       "      <td>12964779</td>\n",
       "      <td>4.634631e+08</td>\n",
       "      <td>9.215000e+09</td>\n",
       "      <td>2.635490e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4628</th>\n",
       "      <td>2001-08-27</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>35.55</td>\n",
       "      <td>37.78</td>\n",
       "      <td>32.85</td>\n",
       "      <td>34.51</td>\n",
       "      <td>31.39</td>\n",
       "      <td>4.16</td>\n",
       "      <td>13.2526</td>\n",
       "      <td>56.8277</td>\n",
       "      <td>40631800</td>\n",
       "      <td>1.410347e+09</td>\n",
       "      <td>8.887500e+09</td>\n",
       "      <td>2.541825e+09</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              日期     股票代码      名称      收盘价      最高价      最低价      开盘价  \\\n",
       "159   2020-02-03  '600519    贵州茅台  1003.92  1010.68   980.00   985.00   \n",
       "174   2020-01-03  '600519    贵州茅台  1078.56  1117.00  1076.90  1117.00   \n",
       "175   2020-01-02  '600519    贵州茅台  1130.00  1145.06  1116.00  1128.00   \n",
       "340   2019-05-06  '600519    贵州茅台   906.00   935.00   893.00   925.50   \n",
       "463   2018-10-30  '600519    贵州茅台   524.00   543.00   509.02   510.00   \n",
       "468   2018-10-23  '600519    贵州茅台   641.74   689.00   635.00   689.00   \n",
       "664   2017-12-28  '600519    贵州茅台   718.69   719.90   671.32   687.00   \n",
       "690   2017-11-22  '600519    贵州茅台   650.52   688.00   650.00   677.00   \n",
       "693   2017-11-17  '600519    贵州茅台   690.25   709.00   677.77   696.00   \n",
       "1236  2015-08-25  '600519    贵州茅台   176.59   182.51   166.20   167.46   \n",
       "1267  2015-07-13  '600519    贵州茅台   257.75   265.58   251.00   258.00   \n",
       "1268  2015-07-10  '600519    贵州茅台   265.59   283.00   251.96   257.00   \n",
       "1269  2015-07-09  '600519    贵州茅台   257.94   260.41   233.00   236.86   \n",
       "1270  2015-07-08  '600519    贵州茅台   236.86   244.99   219.76   229.00   \n",
       "1271  2015-07-07  '600519    贵州茅台   244.18   256.58   239.50   250.00   \n",
       "1272  2015-07-06  '600519    贵州茅台   254.04   267.99   239.50   267.95   \n",
       "1276  2015-06-30  '600519    贵州茅台   257.65   259.82   246.00   246.64   \n",
       "1277  2015-06-29  '600519    贵州茅台   246.64   256.50   227.80   248.37   \n",
       "1323  2015-04-22  '600519    贵州茅台   263.89   269.00   257.11   268.80   \n",
       "1324  2015-04-21  '600519    贵州茅台   257.43   257.43   240.00   240.00   \n",
       "1325  2015-04-20  '600519    贵州茅台   234.03   245.70   229.00   230.00   \n",
       "1326  2015-04-17  '600519    贵州茅台   232.56   248.70   228.28   238.90   \n",
       "1333  2015-04-08  '600519    贵州茅台   204.50   210.68   201.59   202.50   \n",
       "1411  2014-12-09  '600519    贵州茅台   172.86   186.62   171.50   172.00   \n",
       "1427  2014-11-17  '600519    贵州茅台   160.05   168.00   160.00   168.00   \n",
       "1718  2013-09-03  '600519    贵州茅台   151.66   152.80   149.00   151.00   \n",
       "1719  2013-09-02  '600519    贵州茅台   151.92   160.80   151.90   160.80   \n",
       "1861  2013-01-28  '600519    贵州茅台   178.50   187.80   178.00   186.00   \n",
       "2400  2010-11-12  '600519    贵州茅台   177.53   188.08   175.52   175.55   \n",
       "2402  2010-11-10  '600519    贵州茅台   179.73   182.45   166.50   166.60   \n",
       "2547  2010-04-02  '600519    贵州茅台   152.63   158.00   151.60   158.00   \n",
       "3256  2007-05-14  '600519    贵州茅台    94.39   100.78    92.18    93.60   \n",
       "3259  2007-05-09  '600519    贵州茅台    92.00    96.51    89.90    96.50   \n",
       "3486  2006-05-31  '600519  G 茅  台    48.02    51.90    46.88    48.45   \n",
       "3487  2006-05-30  '600519  G 茅  台    48.39    48.39    45.61    47.10   \n",
       "3490  2006-05-25  '600519  G 茅  台    39.59    47.00    38.10    45.00   \n",
       "4627  2001-08-28  '600519    贵州茅台    36.86    37.00    34.61    34.99   \n",
       "4628  2001-08-27  '600519    贵州茅台    35.55    37.78    32.85    34.51   \n",
       "\n",
       "          前收盘     涨跌额       涨跌幅      换手率       成交量          成交金额  \\\n",
       "159   1052.80  -48.88   -4.6429   0.9827  12344288  1.231499e+10   \n",
       "174   1130.00  -51.44   -4.5522   1.0374  13031878  1.426638e+10   \n",
       "175   1183.00   -53.0   -4.4801   1.1789  14809916  1.669684e+10   \n",
       "340    974.00   -68.0   -6.9815   1.0755  13509968  1.229940e+10   \n",
       "463    549.09  -25.09   -4.5694   1.6271  20439667  1.066339e+10   \n",
       "468    693.00  -51.26   -7.3968   0.9800  12311273  8.076619e+09   \n",
       "664    664.18   54.51    8.2071   0.9882  12414107  8.656876e+09   \n",
       "690    677.25  -26.73   -3.9468   1.0229  12849826  8.528143e+09   \n",
       "693    719.11  -28.86   -4.0133   0.9860  12386124  8.548748e+09   \n",
       "1236   169.64    6.95    4.0969   0.9798  12308058  2.165824e+09   \n",
       "1267   265.59   -7.84   -2.9519   1.3041  14892616  3.838169e+09   \n",
       "1268   257.94    7.65    2.9658   2.2430  25614930  6.888908e+09   \n",
       "1269   236.86   21.08    8.8998   1.2102  13820334  3.409951e+09   \n",
       "1270   244.18   -7.32   -2.9978   2.5319  28914054  6.738027e+09   \n",
       "1271   254.04   -9.86   -3.8813   1.4673  16756224  4.121732e+09   \n",
       "1272   249.81    4.23    1.6933   2.3888  27279966  7.012491e+09   \n",
       "1276   246.64   11.01     4.464   1.1059  12629819  3.205286e+09   \n",
       "1277   242.45    4.19    1.7282   1.4455  16507167  4.057070e+09   \n",
       "1323   257.43    6.46    2.5094   1.1789  13463506  3.543577e+09   \n",
       "1324   234.03    23.4    9.9987   1.0718  12240188  3.039244e+09   \n",
       "1325   232.56    1.47    0.6321   1.1435  13058871  3.118765e+09   \n",
       "1326   226.27    6.29    2.7799   1.6821  19209491  4.577504e+09   \n",
       "1333   200.67    3.83    1.9086   1.1896  13585716  2.798382e+09   \n",
       "1411   172.97   -0.11   -0.0636   1.3300  15189028  2.713372e+09   \n",
       "1427   157.29    2.76    1.7547   1.3171  15041623  2.451674e+09   \n",
       "1718   151.92   -0.26   -0.1711   1.1868  12321105  1.855979e+09   \n",
       "1719   168.78  -16.86   -9.9893   2.1670  22497074  3.438419e+09   \n",
       "1861   189.05  -10.55   -5.5805   1.5247  15829058  2.857093e+09   \n",
       "2400   175.92    1.61    0.9152   1.3403  12650029  2.298576e+09   \n",
       "2402   165.86   13.87    8.3625   1.5894  15000509  2.670067e+09   \n",
       "2547   160.06   -7.43    -4.642   1.6347  15428170  2.359759e+09   \n",
       "3256    92.00    2.39    2.5978   4.3620  13187045  1.263779e+09   \n",
       "3259    96.50    -4.5   -4.6632   5.0204  15177660  1.394029e+09   \n",
       "3486    48.39   -0.37   -0.7646   5.0189  15173103  7.474115e+08   \n",
       "3487    43.99     4.4   10.0023   4.5898  13875854  6.647766e+08   \n",
       "3490    44.97   -5.38  -11.9635   6.5533  19811697  8.119087e+08   \n",
       "4627    35.55    1.31     3.685  18.1326  12964779  4.634631e+08   \n",
       "4628    31.39    4.16   13.2526  56.8277  40631800  1.410347e+09   \n",
       "\n",
       "               总市值          流通市值  \n",
       "159   1.261122e+12  1.261122e+12  \n",
       "174   1.354885e+12  1.354885e+12  \n",
       "175   1.419504e+12  1.419504e+12  \n",
       "340   1.138115e+12  1.138115e+12  \n",
       "463   6.582476e+11  6.582476e+11  \n",
       "468   8.061524e+11  8.061524e+11  \n",
       "664   9.028168e+11  9.028168e+11  \n",
       "690   8.171818e+11  8.171818e+11  \n",
       "693   8.670905e+11  8.670905e+11  \n",
       "1236  2.218320e+11  2.218320e+11  \n",
       "1267  2.943500e+11  2.943500e+11  \n",
       "1268  3.033032e+11  3.033032e+11  \n",
       "1269  2.945670e+11  2.945670e+11  \n",
       "1270  2.704936e+11  2.704936e+11  \n",
       "1271  2.788531e+11  2.788531e+11  \n",
       "1272  2.901132e+11  2.901132e+11  \n",
       "1276  2.942358e+11  2.942358e+11  \n",
       "1277  2.816624e+11  2.816624e+11  \n",
       "1323  3.013619e+11  3.013619e+11  \n",
       "1324  2.939845e+11  2.939845e+11  \n",
       "1325  2.672618e+11  2.672618e+11  \n",
       "1326  2.655831e+11  2.655831e+11  \n",
       "1333  2.335386e+11  2.335386e+11  \n",
       "1411  1.974058e+11  1.974058e+11  \n",
       "1427  1.827768e+11  1.827768e+11  \n",
       "1718  1.574504e+11  1.574504e+11  \n",
       "1719  1.577203e+11  1.577203e+11  \n",
       "1861  1.853151e+11  1.853151e+11  \n",
       "2400  1.675528e+11  1.675528e+11  \n",
       "2402  1.696292e+11  1.696292e+11  \n",
       "2547  1.440522e+11  1.440522e+11  \n",
       "3256  8.908528e+10  2.853580e+10  \n",
       "3259  8.682960e+10  2.781326e+10  \n",
       "3486  4.532128e+10  1.451731e+10  \n",
       "3487  4.567048e+10  1.462917e+10  \n",
       "3490  3.736504e+10  1.196877e+10  \n",
       "4627  9.215000e+09  2.635490e+09  \n",
       "4628  8.887500e+09  2.541825e+09  "
      ]
     },
     "execution_count": 71,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "flag = (int)(input())\n",
    "df[df['成交量']>flag]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "12222222\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>日期</th>\n",
       "      <th>股票代码</th>\n",
       "      <th>名称</th>\n",
       "      <th>收盘价</th>\n",
       "      <th>最高价</th>\n",
       "      <th>最低价</th>\n",
       "      <th>开盘价</th>\n",
       "      <th>前收盘</th>\n",
       "      <th>涨跌额</th>\n",
       "      <th>涨跌幅</th>\n",
       "      <th>换手率</th>\n",
       "      <th>成交量</th>\n",
       "      <th>成交金额</th>\n",
       "      <th>总市值</th>\n",
       "      <th>流通市值</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>2020-02-03</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>1003.92</td>\n",
       "      <td>1010.68</td>\n",
       "      <td>980.00</td>\n",
       "      <td>985.00</td>\n",
       "      <td>1052.80</td>\n",
       "      <td>-48.88</td>\n",
       "      <td>-4.6429</td>\n",
       "      <td>0.9827</td>\n",
       "      <td>12344288</td>\n",
       "      <td>1.231499e+10</td>\n",
       "      <td>1.261122e+12</td>\n",
       "      <td>1.261122e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>174</th>\n",
       "      <td>2020-01-03</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>1078.56</td>\n",
       "      <td>1117.00</td>\n",
       "      <td>1076.90</td>\n",
       "      <td>1117.00</td>\n",
       "      <td>1130.00</td>\n",
       "      <td>-51.44</td>\n",
       "      <td>-4.5522</td>\n",
       "      <td>1.0374</td>\n",
       "      <td>13031878</td>\n",
       "      <td>1.426638e+10</td>\n",
       "      <td>1.354885e+12</td>\n",
       "      <td>1.354885e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>2020-01-02</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>1130.00</td>\n",
       "      <td>1145.06</td>\n",
       "      <td>1116.00</td>\n",
       "      <td>1128.00</td>\n",
       "      <td>1183.00</td>\n",
       "      <td>-53.0</td>\n",
       "      <td>-4.4801</td>\n",
       "      <td>1.1789</td>\n",
       "      <td>14809916</td>\n",
       "      <td>1.669684e+10</td>\n",
       "      <td>1.419504e+12</td>\n",
       "      <td>1.419504e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>340</th>\n",
       "      <td>2019-05-06</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>906.00</td>\n",
       "      <td>935.00</td>\n",
       "      <td>893.00</td>\n",
       "      <td>925.50</td>\n",
       "      <td>974.00</td>\n",
       "      <td>-68.0</td>\n",
       "      <td>-6.9815</td>\n",
       "      <td>1.0755</td>\n",
       "      <td>13509968</td>\n",
       "      <td>1.229940e+10</td>\n",
       "      <td>1.138115e+12</td>\n",
       "      <td>1.138115e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>463</th>\n",
       "      <td>2018-10-30</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>524.00</td>\n",
       "      <td>543.00</td>\n",
       "      <td>509.02</td>\n",
       "      <td>510.00</td>\n",
       "      <td>549.09</td>\n",
       "      <td>-25.09</td>\n",
       "      <td>-4.5694</td>\n",
       "      <td>1.6271</td>\n",
       "      <td>20439667</td>\n",
       "      <td>1.066339e+10</td>\n",
       "      <td>6.582476e+11</td>\n",
       "      <td>6.582476e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>468</th>\n",
       "      <td>2018-10-23</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>641.74</td>\n",
       "      <td>689.00</td>\n",
       "      <td>635.00</td>\n",
       "      <td>689.00</td>\n",
       "      <td>693.00</td>\n",
       "      <td>-51.26</td>\n",
       "      <td>-7.3968</td>\n",
       "      <td>0.9800</td>\n",
       "      <td>12311273</td>\n",
       "      <td>8.076619e+09</td>\n",
       "      <td>8.061524e+11</td>\n",
       "      <td>8.061524e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>664</th>\n",
       "      <td>2017-12-28</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>718.69</td>\n",
       "      <td>719.90</td>\n",
       "      <td>671.32</td>\n",
       "      <td>687.00</td>\n",
       "      <td>664.18</td>\n",
       "      <td>54.51</td>\n",
       "      <td>8.2071</td>\n",
       "      <td>0.9882</td>\n",
       "      <td>12414107</td>\n",
       "      <td>8.656876e+09</td>\n",
       "      <td>9.028168e+11</td>\n",
       "      <td>9.028168e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>690</th>\n",
       "      <td>2017-11-22</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>650.52</td>\n",
       "      <td>688.00</td>\n",
       "      <td>650.00</td>\n",
       "      <td>677.00</td>\n",
       "      <td>677.25</td>\n",
       "      <td>-26.73</td>\n",
       "      <td>-3.9468</td>\n",
       "      <td>1.0229</td>\n",
       "      <td>12849826</td>\n",
       "      <td>8.528143e+09</td>\n",
       "      <td>8.171818e+11</td>\n",
       "      <td>8.171818e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>693</th>\n",
       "      <td>2017-11-17</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>690.25</td>\n",
       "      <td>709.00</td>\n",
       "      <td>677.77</td>\n",
       "      <td>696.00</td>\n",
       "      <td>719.11</td>\n",
       "      <td>-28.86</td>\n",
       "      <td>-4.0133</td>\n",
       "      <td>0.9860</td>\n",
       "      <td>12386124</td>\n",
       "      <td>8.548748e+09</td>\n",
       "      <td>8.670905e+11</td>\n",
       "      <td>8.670905e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1236</th>\n",
       "      <td>2015-08-25</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>176.59</td>\n",
       "      <td>182.51</td>\n",
       "      <td>166.20</td>\n",
       "      <td>167.46</td>\n",
       "      <td>169.64</td>\n",
       "      <td>6.95</td>\n",
       "      <td>4.0969</td>\n",
       "      <td>0.9798</td>\n",
       "      <td>12308058</td>\n",
       "      <td>2.165824e+09</td>\n",
       "      <td>2.218320e+11</td>\n",
       "      <td>2.218320e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1267</th>\n",
       "      <td>2015-07-13</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>257.75</td>\n",
       "      <td>265.58</td>\n",
       "      <td>251.00</td>\n",
       "      <td>258.00</td>\n",
       "      <td>265.59</td>\n",
       "      <td>-7.84</td>\n",
       "      <td>-2.9519</td>\n",
       "      <td>1.3041</td>\n",
       "      <td>14892616</td>\n",
       "      <td>3.838169e+09</td>\n",
       "      <td>2.943500e+11</td>\n",
       "      <td>2.943500e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1268</th>\n",
       "      <td>2015-07-10</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>265.59</td>\n",
       "      <td>283.00</td>\n",
       "      <td>251.96</td>\n",
       "      <td>257.00</td>\n",
       "      <td>257.94</td>\n",
       "      <td>7.65</td>\n",
       "      <td>2.9658</td>\n",
       "      <td>2.2430</td>\n",
       "      <td>25614930</td>\n",
       "      <td>6.888908e+09</td>\n",
       "      <td>3.033032e+11</td>\n",
       "      <td>3.033032e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1269</th>\n",
       "      <td>2015-07-09</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>257.94</td>\n",
       "      <td>260.41</td>\n",
       "      <td>233.00</td>\n",
       "      <td>236.86</td>\n",
       "      <td>236.86</td>\n",
       "      <td>21.08</td>\n",
       "      <td>8.8998</td>\n",
       "      <td>1.2102</td>\n",
       "      <td>13820334</td>\n",
       "      <td>3.409951e+09</td>\n",
       "      <td>2.945670e+11</td>\n",
       "      <td>2.945670e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1270</th>\n",
       "      <td>2015-07-08</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>236.86</td>\n",
       "      <td>244.99</td>\n",
       "      <td>219.76</td>\n",
       "      <td>229.00</td>\n",
       "      <td>244.18</td>\n",
       "      <td>-7.32</td>\n",
       "      <td>-2.9978</td>\n",
       "      <td>2.5319</td>\n",
       "      <td>28914054</td>\n",
       "      <td>6.738027e+09</td>\n",
       "      <td>2.704936e+11</td>\n",
       "      <td>2.704936e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1271</th>\n",
       "      <td>2015-07-07</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>244.18</td>\n",
       "      <td>256.58</td>\n",
       "      <td>239.50</td>\n",
       "      <td>250.00</td>\n",
       "      <td>254.04</td>\n",
       "      <td>-9.86</td>\n",
       "      <td>-3.8813</td>\n",
       "      <td>1.4673</td>\n",
       "      <td>16756224</td>\n",
       "      <td>4.121732e+09</td>\n",
       "      <td>2.788531e+11</td>\n",
       "      <td>2.788531e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1272</th>\n",
       "      <td>2015-07-06</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>254.04</td>\n",
       "      <td>267.99</td>\n",
       "      <td>239.50</td>\n",
       "      <td>267.95</td>\n",
       "      <td>249.81</td>\n",
       "      <td>4.23</td>\n",
       "      <td>1.6933</td>\n",
       "      <td>2.3888</td>\n",
       "      <td>27279966</td>\n",
       "      <td>7.012491e+09</td>\n",
       "      <td>2.901132e+11</td>\n",
       "      <td>2.901132e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1276</th>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>257.65</td>\n",
       "      <td>259.82</td>\n",
       "      <td>246.00</td>\n",
       "      <td>246.64</td>\n",
       "      <td>246.64</td>\n",
       "      <td>11.01</td>\n",
       "      <td>4.464</td>\n",
       "      <td>1.1059</td>\n",
       "      <td>12629819</td>\n",
       "      <td>3.205286e+09</td>\n",
       "      <td>2.942358e+11</td>\n",
       "      <td>2.942358e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1277</th>\n",
       "      <td>2015-06-29</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>246.64</td>\n",
       "      <td>256.50</td>\n",
       "      <td>227.80</td>\n",
       "      <td>248.37</td>\n",
       "      <td>242.45</td>\n",
       "      <td>4.19</td>\n",
       "      <td>1.7282</td>\n",
       "      <td>1.4455</td>\n",
       "      <td>16507167</td>\n",
       "      <td>4.057070e+09</td>\n",
       "      <td>2.816624e+11</td>\n",
       "      <td>2.816624e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1323</th>\n",
       "      <td>2015-04-22</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>263.89</td>\n",
       "      <td>269.00</td>\n",
       "      <td>257.11</td>\n",
       "      <td>268.80</td>\n",
       "      <td>257.43</td>\n",
       "      <td>6.46</td>\n",
       "      <td>2.5094</td>\n",
       "      <td>1.1789</td>\n",
       "      <td>13463506</td>\n",
       "      <td>3.543577e+09</td>\n",
       "      <td>3.013619e+11</td>\n",
       "      <td>3.013619e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1324</th>\n",
       "      <td>2015-04-21</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>257.43</td>\n",
       "      <td>257.43</td>\n",
       "      <td>240.00</td>\n",
       "      <td>240.00</td>\n",
       "      <td>234.03</td>\n",
       "      <td>23.4</td>\n",
       "      <td>9.9987</td>\n",
       "      <td>1.0718</td>\n",
       "      <td>12240188</td>\n",
       "      <td>3.039244e+09</td>\n",
       "      <td>2.939845e+11</td>\n",
       "      <td>2.939845e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1325</th>\n",
       "      <td>2015-04-20</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>234.03</td>\n",
       "      <td>245.70</td>\n",
       "      <td>229.00</td>\n",
       "      <td>230.00</td>\n",
       "      <td>232.56</td>\n",
       "      <td>1.47</td>\n",
       "      <td>0.6321</td>\n",
       "      <td>1.1435</td>\n",
       "      <td>13058871</td>\n",
       "      <td>3.118765e+09</td>\n",
       "      <td>2.672618e+11</td>\n",
       "      <td>2.672618e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1326</th>\n",
       "      <td>2015-04-17</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>232.56</td>\n",
       "      <td>248.70</td>\n",
       "      <td>228.28</td>\n",
       "      <td>238.90</td>\n",
       "      <td>226.27</td>\n",
       "      <td>6.29</td>\n",
       "      <td>2.7799</td>\n",
       "      <td>1.6821</td>\n",
       "      <td>19209491</td>\n",
       "      <td>4.577504e+09</td>\n",
       "      <td>2.655831e+11</td>\n",
       "      <td>2.655831e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1333</th>\n",
       "      <td>2015-04-08</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>204.50</td>\n",
       "      <td>210.68</td>\n",
       "      <td>201.59</td>\n",
       "      <td>202.50</td>\n",
       "      <td>200.67</td>\n",
       "      <td>3.83</td>\n",
       "      <td>1.9086</td>\n",
       "      <td>1.1896</td>\n",
       "      <td>13585716</td>\n",
       "      <td>2.798382e+09</td>\n",
       "      <td>2.335386e+11</td>\n",
       "      <td>2.335386e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1411</th>\n",
       "      <td>2014-12-09</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>172.86</td>\n",
       "      <td>186.62</td>\n",
       "      <td>171.50</td>\n",
       "      <td>172.00</td>\n",
       "      <td>172.97</td>\n",
       "      <td>-0.11</td>\n",
       "      <td>-0.0636</td>\n",
       "      <td>1.3300</td>\n",
       "      <td>15189028</td>\n",
       "      <td>2.713372e+09</td>\n",
       "      <td>1.974058e+11</td>\n",
       "      <td>1.974058e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1427</th>\n",
       "      <td>2014-11-17</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>160.05</td>\n",
       "      <td>168.00</td>\n",
       "      <td>160.00</td>\n",
       "      <td>168.00</td>\n",
       "      <td>157.29</td>\n",
       "      <td>2.76</td>\n",
       "      <td>1.7547</td>\n",
       "      <td>1.3171</td>\n",
       "      <td>15041623</td>\n",
       "      <td>2.451674e+09</td>\n",
       "      <td>1.827768e+11</td>\n",
       "      <td>1.827768e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1718</th>\n",
       "      <td>2013-09-03</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>151.66</td>\n",
       "      <td>152.80</td>\n",
       "      <td>149.00</td>\n",
       "      <td>151.00</td>\n",
       "      <td>151.92</td>\n",
       "      <td>-0.26</td>\n",
       "      <td>-0.1711</td>\n",
       "      <td>1.1868</td>\n",
       "      <td>12321105</td>\n",
       "      <td>1.855979e+09</td>\n",
       "      <td>1.574504e+11</td>\n",
       "      <td>1.574504e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1719</th>\n",
       "      <td>2013-09-02</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>151.92</td>\n",
       "      <td>160.80</td>\n",
       "      <td>151.90</td>\n",
       "      <td>160.80</td>\n",
       "      <td>168.78</td>\n",
       "      <td>-16.86</td>\n",
       "      <td>-9.9893</td>\n",
       "      <td>2.1670</td>\n",
       "      <td>22497074</td>\n",
       "      <td>3.438419e+09</td>\n",
       "      <td>1.577203e+11</td>\n",
       "      <td>1.577203e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1861</th>\n",
       "      <td>2013-01-28</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>178.50</td>\n",
       "      <td>187.80</td>\n",
       "      <td>178.00</td>\n",
       "      <td>186.00</td>\n",
       "      <td>189.05</td>\n",
       "      <td>-10.55</td>\n",
       "      <td>-5.5805</td>\n",
       "      <td>1.5247</td>\n",
       "      <td>15829058</td>\n",
       "      <td>2.857093e+09</td>\n",
       "      <td>1.853151e+11</td>\n",
       "      <td>1.853151e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2400</th>\n",
       "      <td>2010-11-12</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>177.53</td>\n",
       "      <td>188.08</td>\n",
       "      <td>175.52</td>\n",
       "      <td>175.55</td>\n",
       "      <td>175.92</td>\n",
       "      <td>1.61</td>\n",
       "      <td>0.9152</td>\n",
       "      <td>1.3403</td>\n",
       "      <td>12650029</td>\n",
       "      <td>2.298576e+09</td>\n",
       "      <td>1.675528e+11</td>\n",
       "      <td>1.675528e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2402</th>\n",
       "      <td>2010-11-10</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>179.73</td>\n",
       "      <td>182.45</td>\n",
       "      <td>166.50</td>\n",
       "      <td>166.60</td>\n",
       "      <td>165.86</td>\n",
       "      <td>13.87</td>\n",
       "      <td>8.3625</td>\n",
       "      <td>1.5894</td>\n",
       "      <td>15000509</td>\n",
       "      <td>2.670067e+09</td>\n",
       "      <td>1.696292e+11</td>\n",
       "      <td>1.696292e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2547</th>\n",
       "      <td>2010-04-02</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>152.63</td>\n",
       "      <td>158.00</td>\n",
       "      <td>151.60</td>\n",
       "      <td>158.00</td>\n",
       "      <td>160.06</td>\n",
       "      <td>-7.43</td>\n",
       "      <td>-4.642</td>\n",
       "      <td>1.6347</td>\n",
       "      <td>15428170</td>\n",
       "      <td>2.359759e+09</td>\n",
       "      <td>1.440522e+11</td>\n",
       "      <td>1.440522e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3256</th>\n",
       "      <td>2007-05-14</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>94.39</td>\n",
       "      <td>100.78</td>\n",
       "      <td>92.18</td>\n",
       "      <td>93.60</td>\n",
       "      <td>92.00</td>\n",
       "      <td>2.39</td>\n",
       "      <td>2.5978</td>\n",
       "      <td>4.3620</td>\n",
       "      <td>13187045</td>\n",
       "      <td>1.263779e+09</td>\n",
       "      <td>8.908528e+10</td>\n",
       "      <td>2.853580e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3259</th>\n",
       "      <td>2007-05-09</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>92.00</td>\n",
       "      <td>96.51</td>\n",
       "      <td>89.90</td>\n",
       "      <td>96.50</td>\n",
       "      <td>96.50</td>\n",
       "      <td>-4.5</td>\n",
       "      <td>-4.6632</td>\n",
       "      <td>5.0204</td>\n",
       "      <td>15177660</td>\n",
       "      <td>1.394029e+09</td>\n",
       "      <td>8.682960e+10</td>\n",
       "      <td>2.781326e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3486</th>\n",
       "      <td>2006-05-31</td>\n",
       "      <td>'600519</td>\n",
       "      <td>G 茅  台</td>\n",
       "      <td>48.02</td>\n",
       "      <td>51.90</td>\n",
       "      <td>46.88</td>\n",
       "      <td>48.45</td>\n",
       "      <td>48.39</td>\n",
       "      <td>-0.37</td>\n",
       "      <td>-0.7646</td>\n",
       "      <td>5.0189</td>\n",
       "      <td>15173103</td>\n",
       "      <td>7.474115e+08</td>\n",
       "      <td>4.532128e+10</td>\n",
       "      <td>1.451731e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3487</th>\n",
       "      <td>2006-05-30</td>\n",
       "      <td>'600519</td>\n",
       "      <td>G 茅  台</td>\n",
       "      <td>48.39</td>\n",
       "      <td>48.39</td>\n",
       "      <td>45.61</td>\n",
       "      <td>47.10</td>\n",
       "      <td>43.99</td>\n",
       "      <td>4.4</td>\n",
       "      <td>10.0023</td>\n",
       "      <td>4.5898</td>\n",
       "      <td>13875854</td>\n",
       "      <td>6.647766e+08</td>\n",
       "      <td>4.567048e+10</td>\n",
       "      <td>1.462917e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3490</th>\n",
       "      <td>2006-05-25</td>\n",
       "      <td>'600519</td>\n",
       "      <td>G 茅  台</td>\n",
       "      <td>39.59</td>\n",
       "      <td>47.00</td>\n",
       "      <td>38.10</td>\n",
       "      <td>45.00</td>\n",
       "      <td>44.97</td>\n",
       "      <td>-5.38</td>\n",
       "      <td>-11.9635</td>\n",
       "      <td>6.5533</td>\n",
       "      <td>19811697</td>\n",
       "      <td>8.119087e+08</td>\n",
       "      <td>3.736504e+10</td>\n",
       "      <td>1.196877e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4627</th>\n",
       "      <td>2001-08-28</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>36.86</td>\n",
       "      <td>37.00</td>\n",
       "      <td>34.61</td>\n",
       "      <td>34.99</td>\n",
       "      <td>35.55</td>\n",
       "      <td>1.31</td>\n",
       "      <td>3.685</td>\n",
       "      <td>18.1326</td>\n",
       "      <td>12964779</td>\n",
       "      <td>4.634631e+08</td>\n",
       "      <td>9.215000e+09</td>\n",
       "      <td>2.635490e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4628</th>\n",
       "      <td>2001-08-27</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>35.55</td>\n",
       "      <td>37.78</td>\n",
       "      <td>32.85</td>\n",
       "      <td>34.51</td>\n",
       "      <td>31.39</td>\n",
       "      <td>4.16</td>\n",
       "      <td>13.2526</td>\n",
       "      <td>56.8277</td>\n",
       "      <td>40631800</td>\n",
       "      <td>1.410347e+09</td>\n",
       "      <td>8.887500e+09</td>\n",
       "      <td>2.541825e+09</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              日期     股票代码      名称      收盘价      最高价      最低价      开盘价  \\\n",
       "159   2020-02-03  '600519    贵州茅台  1003.92  1010.68   980.00   985.00   \n",
       "174   2020-01-03  '600519    贵州茅台  1078.56  1117.00  1076.90  1117.00   \n",
       "175   2020-01-02  '600519    贵州茅台  1130.00  1145.06  1116.00  1128.00   \n",
       "340   2019-05-06  '600519    贵州茅台   906.00   935.00   893.00   925.50   \n",
       "463   2018-10-30  '600519    贵州茅台   524.00   543.00   509.02   510.00   \n",
       "468   2018-10-23  '600519    贵州茅台   641.74   689.00   635.00   689.00   \n",
       "664   2017-12-28  '600519    贵州茅台   718.69   719.90   671.32   687.00   \n",
       "690   2017-11-22  '600519    贵州茅台   650.52   688.00   650.00   677.00   \n",
       "693   2017-11-17  '600519    贵州茅台   690.25   709.00   677.77   696.00   \n",
       "1236  2015-08-25  '600519    贵州茅台   176.59   182.51   166.20   167.46   \n",
       "1267  2015-07-13  '600519    贵州茅台   257.75   265.58   251.00   258.00   \n",
       "1268  2015-07-10  '600519    贵州茅台   265.59   283.00   251.96   257.00   \n",
       "1269  2015-07-09  '600519    贵州茅台   257.94   260.41   233.00   236.86   \n",
       "1270  2015-07-08  '600519    贵州茅台   236.86   244.99   219.76   229.00   \n",
       "1271  2015-07-07  '600519    贵州茅台   244.18   256.58   239.50   250.00   \n",
       "1272  2015-07-06  '600519    贵州茅台   254.04   267.99   239.50   267.95   \n",
       "1276  2015-06-30  '600519    贵州茅台   257.65   259.82   246.00   246.64   \n",
       "1277  2015-06-29  '600519    贵州茅台   246.64   256.50   227.80   248.37   \n",
       "1323  2015-04-22  '600519    贵州茅台   263.89   269.00   257.11   268.80   \n",
       "1324  2015-04-21  '600519    贵州茅台   257.43   257.43   240.00   240.00   \n",
       "1325  2015-04-20  '600519    贵州茅台   234.03   245.70   229.00   230.00   \n",
       "1326  2015-04-17  '600519    贵州茅台   232.56   248.70   228.28   238.90   \n",
       "1333  2015-04-08  '600519    贵州茅台   204.50   210.68   201.59   202.50   \n",
       "1411  2014-12-09  '600519    贵州茅台   172.86   186.62   171.50   172.00   \n",
       "1427  2014-11-17  '600519    贵州茅台   160.05   168.00   160.00   168.00   \n",
       "1718  2013-09-03  '600519    贵州茅台   151.66   152.80   149.00   151.00   \n",
       "1719  2013-09-02  '600519    贵州茅台   151.92   160.80   151.90   160.80   \n",
       "1861  2013-01-28  '600519    贵州茅台   178.50   187.80   178.00   186.00   \n",
       "2400  2010-11-12  '600519    贵州茅台   177.53   188.08   175.52   175.55   \n",
       "2402  2010-11-10  '600519    贵州茅台   179.73   182.45   166.50   166.60   \n",
       "2547  2010-04-02  '600519    贵州茅台   152.63   158.00   151.60   158.00   \n",
       "3256  2007-05-14  '600519    贵州茅台    94.39   100.78    92.18    93.60   \n",
       "3259  2007-05-09  '600519    贵州茅台    92.00    96.51    89.90    96.50   \n",
       "3486  2006-05-31  '600519  G 茅  台    48.02    51.90    46.88    48.45   \n",
       "3487  2006-05-30  '600519  G 茅  台    48.39    48.39    45.61    47.10   \n",
       "3490  2006-05-25  '600519  G 茅  台    39.59    47.00    38.10    45.00   \n",
       "4627  2001-08-28  '600519    贵州茅台    36.86    37.00    34.61    34.99   \n",
       "4628  2001-08-27  '600519    贵州茅台    35.55    37.78    32.85    34.51   \n",
       "\n",
       "          前收盘     涨跌额       涨跌幅      换手率       成交量          成交金额  \\\n",
       "159   1052.80  -48.88   -4.6429   0.9827  12344288  1.231499e+10   \n",
       "174   1130.00  -51.44   -4.5522   1.0374  13031878  1.426638e+10   \n",
       "175   1183.00   -53.0   -4.4801   1.1789  14809916  1.669684e+10   \n",
       "340    974.00   -68.0   -6.9815   1.0755  13509968  1.229940e+10   \n",
       "463    549.09  -25.09   -4.5694   1.6271  20439667  1.066339e+10   \n",
       "468    693.00  -51.26   -7.3968   0.9800  12311273  8.076619e+09   \n",
       "664    664.18   54.51    8.2071   0.9882  12414107  8.656876e+09   \n",
       "690    677.25  -26.73   -3.9468   1.0229  12849826  8.528143e+09   \n",
       "693    719.11  -28.86   -4.0133   0.9860  12386124  8.548748e+09   \n",
       "1236   169.64    6.95    4.0969   0.9798  12308058  2.165824e+09   \n",
       "1267   265.59   -7.84   -2.9519   1.3041  14892616  3.838169e+09   \n",
       "1268   257.94    7.65    2.9658   2.2430  25614930  6.888908e+09   \n",
       "1269   236.86   21.08    8.8998   1.2102  13820334  3.409951e+09   \n",
       "1270   244.18   -7.32   -2.9978   2.5319  28914054  6.738027e+09   \n",
       "1271   254.04   -9.86   -3.8813   1.4673  16756224  4.121732e+09   \n",
       "1272   249.81    4.23    1.6933   2.3888  27279966  7.012491e+09   \n",
       "1276   246.64   11.01     4.464   1.1059  12629819  3.205286e+09   \n",
       "1277   242.45    4.19    1.7282   1.4455  16507167  4.057070e+09   \n",
       "1323   257.43    6.46    2.5094   1.1789  13463506  3.543577e+09   \n",
       "1324   234.03    23.4    9.9987   1.0718  12240188  3.039244e+09   \n",
       "1325   232.56    1.47    0.6321   1.1435  13058871  3.118765e+09   \n",
       "1326   226.27    6.29    2.7799   1.6821  19209491  4.577504e+09   \n",
       "1333   200.67    3.83    1.9086   1.1896  13585716  2.798382e+09   \n",
       "1411   172.97   -0.11   -0.0636   1.3300  15189028  2.713372e+09   \n",
       "1427   157.29    2.76    1.7547   1.3171  15041623  2.451674e+09   \n",
       "1718   151.92   -0.26   -0.1711   1.1868  12321105  1.855979e+09   \n",
       "1719   168.78  -16.86   -9.9893   2.1670  22497074  3.438419e+09   \n",
       "1861   189.05  -10.55   -5.5805   1.5247  15829058  2.857093e+09   \n",
       "2400   175.92    1.61    0.9152   1.3403  12650029  2.298576e+09   \n",
       "2402   165.86   13.87    8.3625   1.5894  15000509  2.670067e+09   \n",
       "2547   160.06   -7.43    -4.642   1.6347  15428170  2.359759e+09   \n",
       "3256    92.00    2.39    2.5978   4.3620  13187045  1.263779e+09   \n",
       "3259    96.50    -4.5   -4.6632   5.0204  15177660  1.394029e+09   \n",
       "3486    48.39   -0.37   -0.7646   5.0189  15173103  7.474115e+08   \n",
       "3487    43.99     4.4   10.0023   4.5898  13875854  6.647766e+08   \n",
       "3490    44.97   -5.38  -11.9635   6.5533  19811697  8.119087e+08   \n",
       "4627    35.55    1.31     3.685  18.1326  12964779  4.634631e+08   \n",
       "4628    31.39    4.16   13.2526  56.8277  40631800  1.410347e+09   \n",
       "\n",
       "               总市值          流通市值  \n",
       "159   1.261122e+12  1.261122e+12  \n",
       "174   1.354885e+12  1.354885e+12  \n",
       "175   1.419504e+12  1.419504e+12  \n",
       "340   1.138115e+12  1.138115e+12  \n",
       "463   6.582476e+11  6.582476e+11  \n",
       "468   8.061524e+11  8.061524e+11  \n",
       "664   9.028168e+11  9.028168e+11  \n",
       "690   8.171818e+11  8.171818e+11  \n",
       "693   8.670905e+11  8.670905e+11  \n",
       "1236  2.218320e+11  2.218320e+11  \n",
       "1267  2.943500e+11  2.943500e+11  \n",
       "1268  3.033032e+11  3.033032e+11  \n",
       "1269  2.945670e+11  2.945670e+11  \n",
       "1270  2.704936e+11  2.704936e+11  \n",
       "1271  2.788531e+11  2.788531e+11  \n",
       "1272  2.901132e+11  2.901132e+11  \n",
       "1276  2.942358e+11  2.942358e+11  \n",
       "1277  2.816624e+11  2.816624e+11  \n",
       "1323  3.013619e+11  3.013619e+11  \n",
       "1324  2.939845e+11  2.939845e+11  \n",
       "1325  2.672618e+11  2.672618e+11  \n",
       "1326  2.655831e+11  2.655831e+11  \n",
       "1333  2.335386e+11  2.335386e+11  \n",
       "1411  1.974058e+11  1.974058e+11  \n",
       "1427  1.827768e+11  1.827768e+11  \n",
       "1718  1.574504e+11  1.574504e+11  \n",
       "1719  1.577203e+11  1.577203e+11  \n",
       "1861  1.853151e+11  1.853151e+11  \n",
       "2400  1.675528e+11  1.675528e+11  \n",
       "2402  1.696292e+11  1.696292e+11  \n",
       "2547  1.440522e+11  1.440522e+11  \n",
       "3256  8.908528e+10  2.853580e+10  \n",
       "3259  8.682960e+10  2.781326e+10  \n",
       "3486  4.532128e+10  1.451731e+10  \n",
       "3487  4.567048e+10  1.462917e+10  \n",
       "3490  3.736504e+10  1.196877e+10  \n",
       "4627  9.215000e+09  2.635490e+09  \n",
       "4628  8.887500e+09  2.541825e+09  "
      ]
     },
     "execution_count": 71,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "flag = (int)(input())\n",
    "df[df['成交量']>flag]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1000000000\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>日期</th>\n",
       "      <th>股票代码</th>\n",
       "      <th>名称</th>\n",
       "      <th>收盘价</th>\n",
       "      <th>最高价</th>\n",
       "      <th>最低价</th>\n",
       "      <th>开盘价</th>\n",
       "      <th>前收盘</th>\n",
       "      <th>涨跌额</th>\n",
       "      <th>涨跌幅</th>\n",
       "      <th>换手率</th>\n",
       "      <th>成交量</th>\n",
       "      <th>成交金额</th>\n",
       "      <th>总市值</th>\n",
       "      <th>流通市值</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-09-21</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>1666.80</td>\n",
       "      <td>1692.76</td>\n",
       "      <td>1666.66</td>\n",
       "      <td>1692.76</td>\n",
       "      <td>1695.00</td>\n",
       "      <td>-28.2</td>\n",
       "      <td>-1.6637</td>\n",
       "      <td>0.1787</td>\n",
       "      <td>2244407</td>\n",
       "      <td>3.756765e+09</td>\n",
       "      <td>2.093830e+12</td>\n",
       "      <td>2.093830e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-09-18</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>1695.00</td>\n",
       "      <td>1695.00</td>\n",
       "      <td>1635.01</td>\n",
       "      <td>1665.00</td>\n",
       "      <td>1670.52</td>\n",
       "      <td>24.48</td>\n",
       "      <td>1.4654</td>\n",
       "      <td>0.3757</td>\n",
       "      <td>4720140</td>\n",
       "      <td>7.853673e+09</td>\n",
       "      <td>2.129255e+12</td>\n",
       "      <td>2.129255e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020-09-17</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>1670.52</td>\n",
       "      <td>1700.00</td>\n",
       "      <td>1658.00</td>\n",
       "      <td>1700.00</td>\n",
       "      <td>1725.10</td>\n",
       "      <td>-54.58</td>\n",
       "      <td>-3.1639</td>\n",
       "      <td>0.5069</td>\n",
       "      <td>6367985</td>\n",
       "      <td>1.068335e+10</td>\n",
       "      <td>2.098504e+12</td>\n",
       "      <td>2.098504e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020-09-16</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>1725.10</td>\n",
       "      <td>1764.81</td>\n",
       "      <td>1719.00</td>\n",
       "      <td>1760.00</td>\n",
       "      <td>1760.00</td>\n",
       "      <td>-34.9</td>\n",
       "      <td>-1.983</td>\n",
       "      <td>0.1792</td>\n",
       "      <td>2251598</td>\n",
       "      <td>3.916458e+09</td>\n",
       "      <td>2.167067e+12</td>\n",
       "      <td>2.167067e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020-09-15</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>1760.00</td>\n",
       "      <td>1769.99</td>\n",
       "      <td>1747.75</td>\n",
       "      <td>1769.99</td>\n",
       "      <td>1766.00</td>\n",
       "      <td>-6.0</td>\n",
       "      <td>-0.3398</td>\n",
       "      <td>0.1657</td>\n",
       "      <td>2082087</td>\n",
       "      <td>3.654872e+09</td>\n",
       "      <td>2.210908e+12</td>\n",
       "      <td>2.210908e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2532</th>\n",
       "      <td>2010-04-26</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>136.93</td>\n",
       "      <td>139.58</td>\n",
       "      <td>136.90</td>\n",
       "      <td>139.00</td>\n",
       "      <td>143.83</td>\n",
       "      <td>-6.9</td>\n",
       "      <td>-4.7973</td>\n",
       "      <td>1.1341</td>\n",
       "      <td>10703613</td>\n",
       "      <td>1.480340e+09</td>\n",
       "      <td>1.292345e+11</td>\n",
       "      <td>1.292345e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2547</th>\n",
       "      <td>2010-04-02</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>152.63</td>\n",
       "      <td>158.00</td>\n",
       "      <td>151.60</td>\n",
       "      <td>158.00</td>\n",
       "      <td>160.06</td>\n",
       "      <td>-7.43</td>\n",
       "      <td>-4.642</td>\n",
       "      <td>1.6347</td>\n",
       "      <td>15428170</td>\n",
       "      <td>2.359759e+09</td>\n",
       "      <td>1.440522e+11</td>\n",
       "      <td>1.440522e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3256</th>\n",
       "      <td>2007-05-14</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>94.39</td>\n",
       "      <td>100.78</td>\n",
       "      <td>92.18</td>\n",
       "      <td>93.60</td>\n",
       "      <td>92.00</td>\n",
       "      <td>2.39</td>\n",
       "      <td>2.5978</td>\n",
       "      <td>4.3620</td>\n",
       "      <td>13187045</td>\n",
       "      <td>1.263779e+09</td>\n",
       "      <td>8.908528e+10</td>\n",
       "      <td>2.853580e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3259</th>\n",
       "      <td>2007-05-09</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>92.00</td>\n",
       "      <td>96.51</td>\n",
       "      <td>89.90</td>\n",
       "      <td>96.50</td>\n",
       "      <td>96.50</td>\n",
       "      <td>-4.5</td>\n",
       "      <td>-4.6632</td>\n",
       "      <td>5.0204</td>\n",
       "      <td>15177660</td>\n",
       "      <td>1.394029e+09</td>\n",
       "      <td>8.682960e+10</td>\n",
       "      <td>2.781326e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4628</th>\n",
       "      <td>2001-08-27</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>35.55</td>\n",
       "      <td>37.78</td>\n",
       "      <td>32.85</td>\n",
       "      <td>34.51</td>\n",
       "      <td>31.39</td>\n",
       "      <td>4.16</td>\n",
       "      <td>13.2526</td>\n",
       "      <td>56.8277</td>\n",
       "      <td>40631800</td>\n",
       "      <td>1.410347e+09</td>\n",
       "      <td>8.887500e+09</td>\n",
       "      <td>2.541825e+09</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1178 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              日期     股票代码    名称      收盘价      最高价      最低价      开盘价      前收盘  \\\n",
       "0     2020-09-21  '600519  贵州茅台  1666.80  1692.76  1666.66  1692.76  1695.00   \n",
       "1     2020-09-18  '600519  贵州茅台  1695.00  1695.00  1635.01  1665.00  1670.52   \n",
       "2     2020-09-17  '600519  贵州茅台  1670.52  1700.00  1658.00  1700.00  1725.10   \n",
       "3     2020-09-16  '600519  贵州茅台  1725.10  1764.81  1719.00  1760.00  1760.00   \n",
       "4     2020-09-15  '600519  贵州茅台  1760.00  1769.99  1747.75  1769.99  1766.00   \n",
       "...          ...      ...   ...      ...      ...      ...      ...      ...   \n",
       "2532  2010-04-26  '600519  贵州茅台   136.93   139.58   136.90   139.00   143.83   \n",
       "2547  2010-04-02  '600519  贵州茅台   152.63   158.00   151.60   158.00   160.06   \n",
       "3256  2007-05-14  '600519  贵州茅台    94.39   100.78    92.18    93.60    92.00   \n",
       "3259  2007-05-09  '600519  贵州茅台    92.00    96.51    89.90    96.50    96.50   \n",
       "4628  2001-08-27  '600519  贵州茅台    35.55    37.78    32.85    34.51    31.39   \n",
       "\n",
       "         涨跌额      涨跌幅      换手率       成交量          成交金额           总市值  \\\n",
       "0      -28.2  -1.6637   0.1787   2244407  3.756765e+09  2.093830e+12   \n",
       "1      24.48   1.4654   0.3757   4720140  7.853673e+09  2.129255e+12   \n",
       "2     -54.58  -3.1639   0.5069   6367985  1.068335e+10  2.098504e+12   \n",
       "3      -34.9   -1.983   0.1792   2251598  3.916458e+09  2.167067e+12   \n",
       "4       -6.0  -0.3398   0.1657   2082087  3.654872e+09  2.210908e+12   \n",
       "...      ...      ...      ...       ...           ...           ...   \n",
       "2532    -6.9  -4.7973   1.1341  10703613  1.480340e+09  1.292345e+11   \n",
       "2547   -7.43   -4.642   1.6347  15428170  2.359759e+09  1.440522e+11   \n",
       "3256    2.39   2.5978   4.3620  13187045  1.263779e+09  8.908528e+10   \n",
       "3259    -4.5  -4.6632   5.0204  15177660  1.394029e+09  8.682960e+10   \n",
       "4628    4.16  13.2526  56.8277  40631800  1.410347e+09  8.887500e+09   \n",
       "\n",
       "              流通市值  \n",
       "0     2.093830e+12  \n",
       "1     2.129255e+12  \n",
       "2     2.098504e+12  \n",
       "3     2.167067e+12  \n",
       "4     2.210908e+12  \n",
       "...            ...  \n",
       "2532  1.292345e+11  \n",
       "2547  1.440522e+11  \n",
       "3256  2.853580e+10  \n",
       "3259  2.781326e+10  \n",
       "4628  2.541825e+09  \n",
       "\n",
       "[1178 rows x 15 columns]"
      ]
     },
     "execution_count": 73,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "flag = (int)(input())\n",
    "df[df['成交金额']>flag]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dtype('float64')"
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.iloc[1,10].dtype"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1000000000\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>日期</th>\n",
       "      <th>股票代码</th>\n",
       "      <th>名称</th>\n",
       "      <th>收盘价</th>\n",
       "      <th>最高价</th>\n",
       "      <th>最低价</th>\n",
       "      <th>开盘价</th>\n",
       "      <th>前收盘</th>\n",
       "      <th>涨跌额</th>\n",
       "      <th>涨跌幅</th>\n",
       "      <th>换手率</th>\n",
       "      <th>成交量</th>\n",
       "      <th>成交金额</th>\n",
       "      <th>总市值</th>\n",
       "      <th>流通市值</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-09-21</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>1666.80</td>\n",
       "      <td>1692.76</td>\n",
       "      <td>1666.66</td>\n",
       "      <td>1692.76</td>\n",
       "      <td>1695.00</td>\n",
       "      <td>-28.2</td>\n",
       "      <td>-1.6637</td>\n",
       "      <td>0.1787</td>\n",
       "      <td>2244407</td>\n",
       "      <td>3.756765e+09</td>\n",
       "      <td>2.093830e+12</td>\n",
       "      <td>2.093830e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-09-18</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>1695.00</td>\n",
       "      <td>1695.00</td>\n",
       "      <td>1635.01</td>\n",
       "      <td>1665.00</td>\n",
       "      <td>1670.52</td>\n",
       "      <td>24.48</td>\n",
       "      <td>1.4654</td>\n",
       "      <td>0.3757</td>\n",
       "      <td>4720140</td>\n",
       "      <td>7.853673e+09</td>\n",
       "      <td>2.129255e+12</td>\n",
       "      <td>2.129255e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020-09-17</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>1670.52</td>\n",
       "      <td>1700.00</td>\n",
       "      <td>1658.00</td>\n",
       "      <td>1700.00</td>\n",
       "      <td>1725.10</td>\n",
       "      <td>-54.58</td>\n",
       "      <td>-3.1639</td>\n",
       "      <td>0.5069</td>\n",
       "      <td>6367985</td>\n",
       "      <td>1.068335e+10</td>\n",
       "      <td>2.098504e+12</td>\n",
       "      <td>2.098504e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020-09-16</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>1725.10</td>\n",
       "      <td>1764.81</td>\n",
       "      <td>1719.00</td>\n",
       "      <td>1760.00</td>\n",
       "      <td>1760.00</td>\n",
       "      <td>-34.9</td>\n",
       "      <td>-1.983</td>\n",
       "      <td>0.1792</td>\n",
       "      <td>2251598</td>\n",
       "      <td>3.916458e+09</td>\n",
       "      <td>2.167067e+12</td>\n",
       "      <td>2.167067e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020-09-15</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>1760.00</td>\n",
       "      <td>1769.99</td>\n",
       "      <td>1747.75</td>\n",
       "      <td>1769.99</td>\n",
       "      <td>1766.00</td>\n",
       "      <td>-6.0</td>\n",
       "      <td>-0.3398</td>\n",
       "      <td>0.1657</td>\n",
       "      <td>2082087</td>\n",
       "      <td>3.654872e+09</td>\n",
       "      <td>2.210908e+12</td>\n",
       "      <td>2.210908e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2532</th>\n",
       "      <td>2010-04-26</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>136.93</td>\n",
       "      <td>139.58</td>\n",
       "      <td>136.90</td>\n",
       "      <td>139.00</td>\n",
       "      <td>143.83</td>\n",
       "      <td>-6.9</td>\n",
       "      <td>-4.7973</td>\n",
       "      <td>1.1341</td>\n",
       "      <td>10703613</td>\n",
       "      <td>1.480340e+09</td>\n",
       "      <td>1.292345e+11</td>\n",
       "      <td>1.292345e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2547</th>\n",
       "      <td>2010-04-02</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>152.63</td>\n",
       "      <td>158.00</td>\n",
       "      <td>151.60</td>\n",
       "      <td>158.00</td>\n",
       "      <td>160.06</td>\n",
       "      <td>-7.43</td>\n",
       "      <td>-4.642</td>\n",
       "      <td>1.6347</td>\n",
       "      <td>15428170</td>\n",
       "      <td>2.359759e+09</td>\n",
       "      <td>1.440522e+11</td>\n",
       "      <td>1.440522e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3256</th>\n",
       "      <td>2007-05-14</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>94.39</td>\n",
       "      <td>100.78</td>\n",
       "      <td>92.18</td>\n",
       "      <td>93.60</td>\n",
       "      <td>92.00</td>\n",
       "      <td>2.39</td>\n",
       "      <td>2.5978</td>\n",
       "      <td>4.3620</td>\n",
       "      <td>13187045</td>\n",
       "      <td>1.263779e+09</td>\n",
       "      <td>8.908528e+10</td>\n",
       "      <td>2.853580e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3259</th>\n",
       "      <td>2007-05-09</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>92.00</td>\n",
       "      <td>96.51</td>\n",
       "      <td>89.90</td>\n",
       "      <td>96.50</td>\n",
       "      <td>96.50</td>\n",
       "      <td>-4.5</td>\n",
       "      <td>-4.6632</td>\n",
       "      <td>5.0204</td>\n",
       "      <td>15177660</td>\n",
       "      <td>1.394029e+09</td>\n",
       "      <td>8.682960e+10</td>\n",
       "      <td>2.781326e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4628</th>\n",
       "      <td>2001-08-27</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>35.55</td>\n",
       "      <td>37.78</td>\n",
       "      <td>32.85</td>\n",
       "      <td>34.51</td>\n",
       "      <td>31.39</td>\n",
       "      <td>4.16</td>\n",
       "      <td>13.2526</td>\n",
       "      <td>56.8277</td>\n",
       "      <td>40631800</td>\n",
       "      <td>1.410347e+09</td>\n",
       "      <td>8.887500e+09</td>\n",
       "      <td>2.541825e+09</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1178 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              日期     股票代码    名称      收盘价      最高价      最低价      开盘价      前收盘  \\\n",
       "0     2020-09-21  '600519  贵州茅台  1666.80  1692.76  1666.66  1692.76  1695.00   \n",
       "1     2020-09-18  '600519  贵州茅台  1695.00  1695.00  1635.01  1665.00  1670.52   \n",
       "2     2020-09-17  '600519  贵州茅台  1670.52  1700.00  1658.00  1700.00  1725.10   \n",
       "3     2020-09-16  '600519  贵州茅台  1725.10  1764.81  1719.00  1760.00  1760.00   \n",
       "4     2020-09-15  '600519  贵州茅台  1760.00  1769.99  1747.75  1769.99  1766.00   \n",
       "...          ...      ...   ...      ...      ...      ...      ...      ...   \n",
       "2532  2010-04-26  '600519  贵州茅台   136.93   139.58   136.90   139.00   143.83   \n",
       "2547  2010-04-02  '600519  贵州茅台   152.63   158.00   151.60   158.00   160.06   \n",
       "3256  2007-05-14  '600519  贵州茅台    94.39   100.78    92.18    93.60    92.00   \n",
       "3259  2007-05-09  '600519  贵州茅台    92.00    96.51    89.90    96.50    96.50   \n",
       "4628  2001-08-27  '600519  贵州茅台    35.55    37.78    32.85    34.51    31.39   \n",
       "\n",
       "         涨跌额      涨跌幅      换手率       成交量          成交金额           总市值  \\\n",
       "0      -28.2  -1.6637   0.1787   2244407  3.756765e+09  2.093830e+12   \n",
       "1      24.48   1.4654   0.3757   4720140  7.853673e+09  2.129255e+12   \n",
       "2     -54.58  -3.1639   0.5069   6367985  1.068335e+10  2.098504e+12   \n",
       "3      -34.9   -1.983   0.1792   2251598  3.916458e+09  2.167067e+12   \n",
       "4       -6.0  -0.3398   0.1657   2082087  3.654872e+09  2.210908e+12   \n",
       "...      ...      ...      ...       ...           ...           ...   \n",
       "2532    -6.9  -4.7973   1.1341  10703613  1.480340e+09  1.292345e+11   \n",
       "2547   -7.43   -4.642   1.6347  15428170  2.359759e+09  1.440522e+11   \n",
       "3256    2.39   2.5978   4.3620  13187045  1.263779e+09  8.908528e+10   \n",
       "3259    -4.5  -4.6632   5.0204  15177660  1.394029e+09  8.682960e+10   \n",
       "4628    4.16  13.2526  56.8277  40631800  1.410347e+09  8.887500e+09   \n",
       "\n",
       "              流通市值  \n",
       "0     2.093830e+12  \n",
       "1     2.129255e+12  \n",
       "2     2.098504e+12  \n",
       "3     2.167067e+12  \n",
       "4     2.210908e+12  \n",
       "...            ...  \n",
       "2532  1.292345e+11  \n",
       "2547  1.440522e+11  \n",
       "3256  2.853580e+10  \n",
       "3259  2.781326e+10  \n",
       "4628  2.541825e+09  \n",
       "\n",
       "[1178 rows x 15 columns]"
      ]
     },
     "execution_count": 73,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "flag = (int)(input())\n",
    "df[df['成交金额']>flag]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "metadata": {},
   "outputs": [],
   "source": [
    "def marge(csv_list, outputfile):\n",
    "    for inputfile in csv_list:\n",
    "        f = open(inputfile, 'r', encoding='gb18030',errors='ignore')\n",
    "        data = pd.read_csv(f,encoding='gb18030')\n",
    "        data.to_csv(outputfile, mode='a', index=False)\n",
    "    print('完成合并')\n",
    " \n",
    " #去重保留一个表头\n",
    "def distinct(file):\n",
    "    df = pd.read_csv(file, header=None)\n",
    "    datalist = df.drop_duplicates()\n",
    "    datalist.to_csv( index=False, header=False)\n",
    "    print('完成去重')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "ename": "FileNotFoundError",
     "evalue": "[Errno 2] No such file or directory: '/home/cpj/python/data/lab2/data/margin.csv'",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mFileNotFoundError\u001b[0m                         Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-79-781f83e22fb4>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[1;32m      1\u001b[0m \u001b[0mcsv_file\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;34mr'/home/cpj/python/data/lab2/data/margin.csv'\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 2\u001b[0;31m \u001b[0mcsv\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mpd\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mread_csv\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mcsv_file\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m      3\u001b[0m \u001b[0mdf\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mpd\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mDataFrame\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mcsv\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/usr/local/lib/python3.6/dist-packages/pandas/io/parsers.py\u001b[0m in \u001b[0;36mread_csv\u001b[0;34m(filepath_or_buffer, sep, delimiter, header, names, index_col, usecols, squeeze, prefix, mangle_dupe_cols, dtype, engine, converters, true_values, false_values, skipinitialspace, skiprows, skipfooter, nrows, na_values, keep_default_na, na_filter, verbose, skip_blank_lines, parse_dates, infer_datetime_format, keep_date_col, date_parser, dayfirst, cache_dates, iterator, chunksize, compression, thousands, decimal, lineterminator, quotechar, quoting, doublequote, escapechar, comment, encoding, dialect, error_bad_lines, warn_bad_lines, delim_whitespace, low_memory, memory_map, float_precision)\u001b[0m\n\u001b[1;32m    684\u001b[0m     )\n\u001b[1;32m    685\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 686\u001b[0;31m     \u001b[0;32mreturn\u001b[0m \u001b[0m_read\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mfilepath_or_buffer\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mkwds\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    687\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    688\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/usr/local/lib/python3.6/dist-packages/pandas/io/parsers.py\u001b[0m in \u001b[0;36m_read\u001b[0;34m(filepath_or_buffer, kwds)\u001b[0m\n\u001b[1;32m    450\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    451\u001b[0m     \u001b[0;31m# Create the parser.\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 452\u001b[0;31m     \u001b[0mparser\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mTextFileReader\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mfp_or_buf\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mkwds\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    453\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    454\u001b[0m     \u001b[0;32mif\u001b[0m \u001b[0mchunksize\u001b[0m \u001b[0;32mor\u001b[0m \u001b[0miterator\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/usr/local/lib/python3.6/dist-packages/pandas/io/parsers.py\u001b[0m in \u001b[0;36m__init__\u001b[0;34m(self, f, engine, **kwds)\u001b[0m\n\u001b[1;32m    944\u001b[0m             \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0moptions\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m\"has_index_names\"\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mkwds\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m\"has_index_names\"\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    945\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 946\u001b[0;31m         \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_make_engine\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mengine\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    947\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    948\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0mclose\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/usr/local/lib/python3.6/dist-packages/pandas/io/parsers.py\u001b[0m in \u001b[0;36m_make_engine\u001b[0;34m(self, engine)\u001b[0m\n\u001b[1;32m   1176\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0m_make_engine\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mengine\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m\"c\"\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1177\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0mengine\u001b[0m \u001b[0;34m==\u001b[0m \u001b[0;34m\"c\"\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1178\u001b[0;31m             \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_engine\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mCParserWrapper\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mf\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0moptions\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   1179\u001b[0m         \u001b[0;32melse\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1180\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0mengine\u001b[0m \u001b[0;34m==\u001b[0m \u001b[0;34m\"python\"\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/usr/local/lib/python3.6/dist-packages/pandas/io/parsers.py\u001b[0m in \u001b[0;36m__init__\u001b[0;34m(self, src, **kwds)\u001b[0m\n\u001b[1;32m   2006\u001b[0m         \u001b[0mkwds\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m\"usecols\"\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0musecols\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2007\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 2008\u001b[0;31m         \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_reader\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mparsers\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mTextReader\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0msrc\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mkwds\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   2009\u001b[0m         \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0munnamed_cols\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_reader\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0munnamed_cols\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2010\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32mpandas/_libs/parsers.pyx\u001b[0m in \u001b[0;36mpandas._libs.parsers.TextReader.__cinit__\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;32mpandas/_libs/parsers.pyx\u001b[0m in \u001b[0;36mpandas._libs.parsers.TextReader._setup_parser_source\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;31mFileNotFoundError\u001b[0m: [Errno 2] No such file or directory: '/home/cpj/python/data/lab2/data/margin.csv'"
     ]
    }
   ],
   "source": [
    "csv_file = r'/home/cpj/python/data/lab2/data/margin.csv'\n",
    "csv = pd.read_csv(csv_file)\n",
    "df = pd.DataFrame(csv)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>日期</th>\n",
       "      <th>股票代码</th>\n",
       "      <th>名称</th>\n",
       "      <th>收盘价</th>\n",
       "      <th>最高价</th>\n",
       "      <th>最低价</th>\n",
       "      <th>开盘价</th>\n",
       "      <th>前收盘</th>\n",
       "      <th>涨跌额</th>\n",
       "      <th>涨跌幅</th>\n",
       "      <th>换手率</th>\n",
       "      <th>成交量</th>\n",
       "      <th>成交金额</th>\n",
       "      <th>总市值</th>\n",
       "      <th>流通市值</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-09-21</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>1666.8</td>\n",
       "      <td>1692.76</td>\n",
       "      <td>1666.66</td>\n",
       "      <td>1692.76</td>\n",
       "      <td>1695.0</td>\n",
       "      <td>-28.2</td>\n",
       "      <td>-1.6637</td>\n",
       "      <td>0.1787</td>\n",
       "      <td>2244407</td>\n",
       "      <td>3756765108.0</td>\n",
       "      <td>2093830493040.0</td>\n",
       "      <td>2093830493040.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-09-18</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>1695.0</td>\n",
       "      <td>1695.0</td>\n",
       "      <td>1635.01</td>\n",
       "      <td>1665.0</td>\n",
       "      <td>1670.52</td>\n",
       "      <td>24.48</td>\n",
       "      <td>1.4654</td>\n",
       "      <td>0.3757</td>\n",
       "      <td>4720140</td>\n",
       "      <td>7853673241.0</td>\n",
       "      <td>2129255271000.0</td>\n",
       "      <td>2129255271000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020-09-17</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>1670.52</td>\n",
       "      <td>1700.0</td>\n",
       "      <td>1658.0</td>\n",
       "      <td>1700.0</td>\n",
       "      <td>1725.1</td>\n",
       "      <td>-54.58</td>\n",
       "      <td>-3.1639</td>\n",
       "      <td>0.5069</td>\n",
       "      <td>6367985</td>\n",
       "      <td>10683350187.0</td>\n",
       "      <td>2098503548860.0</td>\n",
       "      <td>2098503548860.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020-09-16</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>1725.1</td>\n",
       "      <td>1764.81</td>\n",
       "      <td>1719.0</td>\n",
       "      <td>1760.0</td>\n",
       "      <td>1760.0</td>\n",
       "      <td>-34.9</td>\n",
       "      <td>-1.983</td>\n",
       "      <td>0.1792</td>\n",
       "      <td>2251598</td>\n",
       "      <td>3916457762.0</td>\n",
       "      <td>2167066824780.0</td>\n",
       "      <td>2167066824780.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020-09-15</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>1760.0</td>\n",
       "      <td>1769.99</td>\n",
       "      <td>1747.75</td>\n",
       "      <td>1769.99</td>\n",
       "      <td>1766.0</td>\n",
       "      <td>-6.0</td>\n",
       "      <td>-0.3398</td>\n",
       "      <td>0.1657</td>\n",
       "      <td>2082087</td>\n",
       "      <td>3654872009.0</td>\n",
       "      <td>2210908128000.0</td>\n",
       "      <td>2210908128000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10062</th>\n",
       "      <td>1998-05-04</td>\n",
       "      <td>'000858</td>\n",
       "      <td>五 粮 液</td>\n",
       "      <td>59.02</td>\n",
       "      <td>59.02</td>\n",
       "      <td>55.0</td>\n",
       "      <td>55.1</td>\n",
       "      <td>53.65</td>\n",
       "      <td>5.37</td>\n",
       "      <td>10.0093</td>\n",
       "      <td>6.8347</td>\n",
       "      <td>4920974</td>\n",
       "      <td>285312925.33</td>\n",
       "      <td>18886400000.0</td>\n",
       "      <td>4249440000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10063</th>\n",
       "      <td>1998-04-30</td>\n",
       "      <td>'000858</td>\n",
       "      <td>五 粮 液</td>\n",
       "      <td>53.65</td>\n",
       "      <td>54.2</td>\n",
       "      <td>53.2</td>\n",
       "      <td>53.3</td>\n",
       "      <td>53.3</td>\n",
       "      <td>0.35</td>\n",
       "      <td>0.6567</td>\n",
       "      <td>3.3135</td>\n",
       "      <td>2385686</td>\n",
       "      <td>127942178.11</td>\n",
       "      <td>17168000000.0</td>\n",
       "      <td>3862800000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10064</th>\n",
       "      <td>1998-04-29</td>\n",
       "      <td>'000858</td>\n",
       "      <td>五 粮 液</td>\n",
       "      <td>53.3</td>\n",
       "      <td>54.98</td>\n",
       "      <td>52.9</td>\n",
       "      <td>54.97</td>\n",
       "      <td>54.19</td>\n",
       "      <td>-0.89</td>\n",
       "      <td>-1.6424</td>\n",
       "      <td>4.7128</td>\n",
       "      <td>3393230</td>\n",
       "      <td>181927515.95</td>\n",
       "      <td>17056000000.0</td>\n",
       "      <td>3837600000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10065</th>\n",
       "      <td>1998-04-28</td>\n",
       "      <td>'000858</td>\n",
       "      <td>五 粮 液</td>\n",
       "      <td>54.19</td>\n",
       "      <td>56.5</td>\n",
       "      <td>53.6</td>\n",
       "      <td>54.0</td>\n",
       "      <td>53.57</td>\n",
       "      <td>0.62</td>\n",
       "      <td>1.1574</td>\n",
       "      <td>9.397</td>\n",
       "      <td>6765827</td>\n",
       "      <td>371571836.1</td>\n",
       "      <td>17340800000.0</td>\n",
       "      <td>3901680000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10066</th>\n",
       "      <td>1998-04-27</td>\n",
       "      <td>'000858</td>\n",
       "      <td>五 粮 液</td>\n",
       "      <td>53.57</td>\n",
       "      <td>57.0</td>\n",
       "      <td>29.77</td>\n",
       "      <td>29.77</td>\n",
       "      <td>0.0</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>47.4487</td>\n",
       "      <td>34163076</td>\n",
       "      <td>1846204586.12</td>\n",
       "      <td>17142400000.0</td>\n",
       "      <td>3857040000.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10067 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               日期     股票代码     名称      收盘价      最高价      最低价      开盘价  \\\n",
       "0      2020-09-21  '600519   贵州茅台   1666.8  1692.76  1666.66  1692.76   \n",
       "1      2020-09-18  '600519   贵州茅台   1695.0   1695.0  1635.01   1665.0   \n",
       "2      2020-09-17  '600519   贵州茅台  1670.52   1700.0   1658.0   1700.0   \n",
       "3      2020-09-16  '600519   贵州茅台   1725.1  1764.81   1719.0   1760.0   \n",
       "4      2020-09-15  '600519   贵州茅台   1760.0  1769.99  1747.75  1769.99   \n",
       "...           ...      ...    ...      ...      ...      ...      ...   \n",
       "10062  1998-05-04  '000858  五 粮 液    59.02    59.02     55.0     55.1   \n",
       "10063  1998-04-30  '000858  五 粮 液    53.65     54.2     53.2     53.3   \n",
       "10064  1998-04-29  '000858  五 粮 液     53.3    54.98     52.9    54.97   \n",
       "10065  1998-04-28  '000858  五 粮 液    54.19     56.5     53.6     54.0   \n",
       "10066  1998-04-27  '000858  五 粮 液    53.57     57.0    29.77    29.77   \n",
       "\n",
       "           前收盘     涨跌额      涨跌幅      换手率       成交量           成交金额  \\\n",
       "0       1695.0   -28.2  -1.6637   0.1787   2244407   3756765108.0   \n",
       "1      1670.52   24.48   1.4654   0.3757   4720140   7853673241.0   \n",
       "2       1725.1  -54.58  -3.1639   0.5069   6367985  10683350187.0   \n",
       "3       1760.0   -34.9   -1.983   0.1792   2251598   3916457762.0   \n",
       "4       1766.0    -6.0  -0.3398   0.1657   2082087   3654872009.0   \n",
       "...        ...     ...      ...      ...       ...            ...   \n",
       "10062    53.65    5.37  10.0093   6.8347   4920974   285312925.33   \n",
       "10063     53.3    0.35   0.6567   3.3135   2385686   127942178.11   \n",
       "10064    54.19   -0.89  -1.6424   4.7128   3393230   181927515.95   \n",
       "10065    53.57    0.62   1.1574    9.397   6765827    371571836.1   \n",
       "10066      0.0    None     None  47.4487  34163076  1846204586.12   \n",
       "\n",
       "                   总市值             流通市值  \n",
       "0      2093830493040.0  2093830493040.0  \n",
       "1      2129255271000.0  2129255271000.0  \n",
       "2      2098503548860.0  2098503548860.0  \n",
       "3      2167066824780.0  2167066824780.0  \n",
       "4      2210908128000.0  2210908128000.0  \n",
       "...                ...              ...  \n",
       "10062    18886400000.0     4249440000.0  \n",
       "10063    17168000000.0     3862800000.0  \n",
       "10064    17056000000.0     3837600000.0  \n",
       "10065    17340800000.0     3901680000.0  \n",
       "10066    17142400000.0     3857040000.0  \n",
       "\n",
       "[10067 rows x 15 columns]"
      ]
     },
     "execution_count": 78,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "10\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>日期</th>\n",
       "      <th>股票代码</th>\n",
       "      <th>名称</th>\n",
       "      <th>收盘价</th>\n",
       "      <th>最高价</th>\n",
       "      <th>最低价</th>\n",
       "      <th>开盘价</th>\n",
       "      <th>前收盘</th>\n",
       "      <th>涨跌额</th>\n",
       "      <th>涨跌幅</th>\n",
       "      <th>换手率</th>\n",
       "      <th>成交量</th>\n",
       "      <th>成交金额</th>\n",
       "      <th>总市值</th>\n",
       "      <th>流通市值</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>2020-07-28</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>1670.0</td>\n",
       "      <td>1680.0</td>\n",
       "      <td>1630.0</td>\n",
       "      <td>1630.0</td>\n",
       "      <td>1622.55</td>\n",
       "      <td>47.45</td>\n",
       "      <td>2.9244</td>\n",
       "      <td>0.4371</td>\n",
       "      <td>5491152</td>\n",
       "      <td>9133721867.0</td>\n",
       "      <td>2097850326000.0</td>\n",
       "      <td>2097850326000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>2020-07-17</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>1648.05</td>\n",
       "      <td>1672.59</td>\n",
       "      <td>1620.0</td>\n",
       "      <td>1620.0</td>\n",
       "      <td>1614.0</td>\n",
       "      <td>34.05</td>\n",
       "      <td>2.1097</td>\n",
       "      <td>0.5246</td>\n",
       "      <td>6590206</td>\n",
       "      <td>10863420089.0</td>\n",
       "      <td>2070276784290.0</td>\n",
       "      <td>2070276784290.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>2020-07-13</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>1781.99</td>\n",
       "      <td>1787.0</td>\n",
       "      <td>1714.68</td>\n",
       "      <td>1714.68</td>\n",
       "      <td>1713.85</td>\n",
       "      <td>68.14</td>\n",
       "      <td>3.9758</td>\n",
       "      <td>0.4834</td>\n",
       "      <td>6072716</td>\n",
       "      <td>10679460274.0</td>\n",
       "      <td>2238531917620.0</td>\n",
       "      <td>2238531917620.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>2020-07-07</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>1688.0</td>\n",
       "      <td>1744.82</td>\n",
       "      <td>1601.0</td>\n",
       "      <td>1603.09</td>\n",
       "      <td>1600.0</td>\n",
       "      <td>88.0</td>\n",
       "      <td>5.5</td>\n",
       "      <td>0.5307</td>\n",
       "      <td>6666393</td>\n",
       "      <td>11219852098.0</td>\n",
       "      <td>2120461886400.0</td>\n",
       "      <td>2120461886400.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>2020-07-06</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>1600.0</td>\n",
       "      <td>1616.0</td>\n",
       "      <td>1531.81</td>\n",
       "      <td>1538.0</td>\n",
       "      <td>1541.79</td>\n",
       "      <td>58.21</td>\n",
       "      <td>3.7755</td>\n",
       "      <td>0.4125</td>\n",
       "      <td>5182196</td>\n",
       "      <td>8228068998.0</td>\n",
       "      <td>2009916480000.0</td>\n",
       "      <td>2009916480000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10035</th>\n",
       "      <td>1998-06-10</td>\n",
       "      <td>'000858</td>\n",
       "      <td>五 粮 液</td>\n",
       "      <td>57.01</td>\n",
       "      <td>58.0</td>\n",
       "      <td>55.5</td>\n",
       "      <td>55.5</td>\n",
       "      <td>55.57</td>\n",
       "      <td>1.44</td>\n",
       "      <td>2.5913</td>\n",
       "      <td>0.7026</td>\n",
       "      <td>505855</td>\n",
       "      <td>28690455.8</td>\n",
       "      <td>18243200000.0</td>\n",
       "      <td>4104720000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10060</th>\n",
       "      <td>1998-05-06</td>\n",
       "      <td>'000858</td>\n",
       "      <td>五 粮 液</td>\n",
       "      <td>65.73</td>\n",
       "      <td>66.0</td>\n",
       "      <td>61.8</td>\n",
       "      <td>62.2</td>\n",
       "      <td>62.66</td>\n",
       "      <td>3.07</td>\n",
       "      <td>4.8995</td>\n",
       "      <td>6.162000000000001</td>\n",
       "      <td>4436626</td>\n",
       "      <td>283147678.47</td>\n",
       "      <td>21033600000.0</td>\n",
       "      <td>4732560000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10061</th>\n",
       "      <td>1998-05-05</td>\n",
       "      <td>'000858</td>\n",
       "      <td>五 粮 液</td>\n",
       "      <td>62.66</td>\n",
       "      <td>64.9</td>\n",
       "      <td>61.61</td>\n",
       "      <td>62.88</td>\n",
       "      <td>59.02</td>\n",
       "      <td>3.64</td>\n",
       "      <td>6.1674</td>\n",
       "      <td>11.6799</td>\n",
       "      <td>8409522</td>\n",
       "      <td>532130549.21</td>\n",
       "      <td>20051200000.0</td>\n",
       "      <td>4511520000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10062</th>\n",
       "      <td>1998-05-04</td>\n",
       "      <td>'000858</td>\n",
       "      <td>五 粮 液</td>\n",
       "      <td>59.02</td>\n",
       "      <td>59.02</td>\n",
       "      <td>55.0</td>\n",
       "      <td>55.1</td>\n",
       "      <td>53.65</td>\n",
       "      <td>5.37</td>\n",
       "      <td>10.0093</td>\n",
       "      <td>6.8347</td>\n",
       "      <td>4920974</td>\n",
       "      <td>285312925.33</td>\n",
       "      <td>18886400000.0</td>\n",
       "      <td>4249440000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10066</th>\n",
       "      <td>1998-04-27</td>\n",
       "      <td>'000858</td>\n",
       "      <td>五 粮 液</td>\n",
       "      <td>53.57</td>\n",
       "      <td>57.0</td>\n",
       "      <td>29.77</td>\n",
       "      <td>29.77</td>\n",
       "      <td>0.0</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>47.4487</td>\n",
       "      <td>34163076</td>\n",
       "      <td>1846204586.12</td>\n",
       "      <td>17142400000.0</td>\n",
       "      <td>3857040000.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1710 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               日期     股票代码     名称      收盘价      最高价      最低价      开盘价  \\\n",
       "39     2020-07-28  '600519   贵州茅台   1670.0   1680.0   1630.0   1630.0   \n",
       "46     2020-07-17  '600519   贵州茅台  1648.05  1672.59   1620.0   1620.0   \n",
       "50     2020-07-13  '600519   贵州茅台  1781.99   1787.0  1714.68  1714.68   \n",
       "54     2020-07-07  '600519   贵州茅台   1688.0  1744.82   1601.0  1603.09   \n",
       "55     2020-07-06  '600519   贵州茅台   1600.0   1616.0  1531.81   1538.0   \n",
       "...           ...      ...    ...      ...      ...      ...      ...   \n",
       "10035  1998-06-10  '000858  五 粮 液    57.01     58.0     55.5     55.5   \n",
       "10060  1998-05-06  '000858  五 粮 液    65.73     66.0     61.8     62.2   \n",
       "10061  1998-05-05  '000858  五 粮 液    62.66     64.9    61.61    62.88   \n",
       "10062  1998-05-04  '000858  五 粮 液    59.02    59.02     55.0     55.1   \n",
       "10066  1998-04-27  '000858  五 粮 液    53.57     57.0    29.77    29.77   \n",
       "\n",
       "           前收盘    涨跌额      涨跌幅                换手率       成交量           成交金额  \\\n",
       "39     1622.55  47.45   2.9244             0.4371   5491152   9133721867.0   \n",
       "46      1614.0  34.05   2.1097             0.5246   6590206  10863420089.0   \n",
       "50     1713.85  68.14   3.9758             0.4834   6072716  10679460274.0   \n",
       "54      1600.0   88.0      5.5             0.5307   6666393  11219852098.0   \n",
       "55     1541.79  58.21   3.7755             0.4125   5182196   8228068998.0   \n",
       "...        ...    ...      ...                ...       ...            ...   \n",
       "10035    55.57   1.44   2.5913             0.7026    505855     28690455.8   \n",
       "10060    62.66   3.07   4.8995  6.162000000000001   4436626   283147678.47   \n",
       "10061    59.02   3.64   6.1674            11.6799   8409522   532130549.21   \n",
       "10062    53.65   5.37  10.0093             6.8347   4920974   285312925.33   \n",
       "10066      0.0   None     None            47.4487  34163076  1846204586.12   \n",
       "\n",
       "                   总市值             流通市值  \n",
       "39     2097850326000.0  2097850326000.0  \n",
       "46     2070276784290.0  2070276784290.0  \n",
       "50     2238531917620.0  2238531917620.0  \n",
       "54     2120461886400.0  2120461886400.0  \n",
       "55     2009916480000.0  2009916480000.0  \n",
       "...                ...              ...  \n",
       "10035    18243200000.0     4104720000.0  \n",
       "10060    21033600000.0     4732560000.0  \n",
       "10061    20051200000.0     4511520000.0  \n",
       "10062    18886400000.0     4249440000.0  \n",
       "10066    17142400000.0     3857040000.0  \n",
       "\n",
       "[1710 rows x 15 columns]"
      ]
     },
     "execution_count": 80,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "flag = input()\n",
    "df[df['涨跌幅']>flag]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "请输入日期：\n",
      "2019-08-08\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>日期</th>\n",
       "      <th>股票代码</th>\n",
       "      <th>名称</th>\n",
       "      <th>收盘价</th>\n",
       "      <th>最高价</th>\n",
       "      <th>最低价</th>\n",
       "      <th>开盘价</th>\n",
       "      <th>前收盘</th>\n",
       "      <th>涨跌额</th>\n",
       "      <th>涨跌幅</th>\n",
       "      <th>换手率</th>\n",
       "      <th>成交量</th>\n",
       "      <th>成交金额</th>\n",
       "      <th>总市值</th>\n",
       "      <th>流通市值</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>273</th>\n",
       "      <td>2019-08-08</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>971.68</td>\n",
       "      <td>974.0</td>\n",
       "      <td>952.0</td>\n",
       "      <td>953.5</td>\n",
       "      <td>945.0</td>\n",
       "      <td>26.68</td>\n",
       "      <td>2.8233</td>\n",
       "      <td>0.3089</td>\n",
       "      <td>3880813</td>\n",
       "      <td>3755086990.0</td>\n",
       "      <td>1220622278300.0</td>\n",
       "      <td>1220622278300.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4903</th>\n",
       "      <td>2019-08-08</td>\n",
       "      <td>'000858</td>\n",
       "      <td>五 粮 液</td>\n",
       "      <td>120.52</td>\n",
       "      <td>121.61</td>\n",
       "      <td>119.26</td>\n",
       "      <td>119.49</td>\n",
       "      <td>118.88</td>\n",
       "      <td>1.64</td>\n",
       "      <td>1.3795</td>\n",
       "      <td>0.6643</td>\n",
       "      <td>25217971</td>\n",
       "      <td>3043542051.97</td>\n",
       "      <td>467811396763.0</td>\n",
       "      <td>457489909094.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              日期     股票代码     名称     收盘价     最高价     最低价     开盘价     前收盘  \\\n",
       "273   2019-08-08  '600519   贵州茅台  971.68   974.0   952.0   953.5   945.0   \n",
       "4903  2019-08-08  '000858  五 粮 液  120.52  121.61  119.26  119.49  118.88   \n",
       "\n",
       "        涨跌额     涨跌幅     换手率       成交量           成交金额              总市值  \\\n",
       "273   26.68  2.8233  0.3089   3880813   3755086990.0  1220622278300.0   \n",
       "4903   1.64  1.3795  0.6643  25217971  3043542051.97   467811396763.0   \n",
       "\n",
       "                 流通市值  \n",
       "273   1220622278300.0  \n",
       "4903   457489909094.0  "
      ]
     },
     "execution_count": 82,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "flag = input(\"请输入日期：\\n2019-08-08\")\n",
    "df[df['日期']==flag]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "9000000\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>日期</th>\n",
       "      <th>股票代码</th>\n",
       "      <th>名称</th>\n",
       "      <th>收盘价</th>\n",
       "      <th>最高价</th>\n",
       "      <th>最低价</th>\n",
       "      <th>开盘价</th>\n",
       "      <th>前收盘</th>\n",
       "      <th>涨跌额</th>\n",
       "      <th>涨跌幅</th>\n",
       "      <th>换手率</th>\n",
       "      <th>成交量</th>\n",
       "      <th>成交金额</th>\n",
       "      <th>总市值</th>\n",
       "      <th>流通市值</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>337</th>\n",
       "      <td>2019-05-09</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>858.81</td>\n",
       "      <td>879.87</td>\n",
       "      <td>842.5</td>\n",
       "      <td>875.0</td>\n",
       "      <td>884.4</td>\n",
       "      <td>-25.59</td>\n",
       "      <td>-2.8935</td>\n",
       "      <td>0.7287</td>\n",
       "      <td>9154515</td>\n",
       "      <td>7863312116.0</td>\n",
       "      <td>1078835232620.0</td>\n",
       "      <td>1078835232620.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>362</th>\n",
       "      <td>2019-03-29</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>853.99</td>\n",
       "      <td>866.68</td>\n",
       "      <td>830.17</td>\n",
       "      <td>835.0</td>\n",
       "      <td>806.8</td>\n",
       "      <td>47.19</td>\n",
       "      <td>5.849</td>\n",
       "      <td>0.7239</td>\n",
       "      <td>9093396</td>\n",
       "      <td>7702154797.0</td>\n",
       "      <td>1072780359220.0</td>\n",
       "      <td>1072780359220.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>461</th>\n",
       "      <td>2018-11-01</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>563.0</td>\n",
       "      <td>585.5</td>\n",
       "      <td>551.25</td>\n",
       "      <td>555.0</td>\n",
       "      <td>548.9</td>\n",
       "      <td>14.1</td>\n",
       "      <td>2.5688</td>\n",
       "      <td>0.7809999999999999</td>\n",
       "      <td>9810672</td>\n",
       "      <td>5581027253.0</td>\n",
       "      <td>707239361400.0</td>\n",
       "      <td>707239361400.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>462</th>\n",
       "      <td>2018-10-31</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>548.9</td>\n",
       "      <td>555.0</td>\n",
       "      <td>522.0</td>\n",
       "      <td>527.0</td>\n",
       "      <td>524.0</td>\n",
       "      <td>24.9</td>\n",
       "      <td>4.7519</td>\n",
       "      <td>0.7713</td>\n",
       "      <td>9688482</td>\n",
       "      <td>5239853122.0</td>\n",
       "      <td>689526972420.0</td>\n",
       "      <td>689526972420.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476</th>\n",
       "      <td>2018-10-11</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>644.99</td>\n",
       "      <td>668.94</td>\n",
       "      <td>635.01</td>\n",
       "      <td>635.01</td>\n",
       "      <td>670.92</td>\n",
       "      <td>-25.93</td>\n",
       "      <td>-3.8648</td>\n",
       "      <td>0.7290000000000001</td>\n",
       "      <td>9158196</td>\n",
       "      <td>5953169079.0</td>\n",
       "      <td>810235019022.0</td>\n",
       "      <td>810235019022.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9899</th>\n",
       "      <td>1998-12-21</td>\n",
       "      <td>'000858</td>\n",
       "      <td>五 粮 液</td>\n",
       "      <td>40.89</td>\n",
       "      <td>41.37</td>\n",
       "      <td>40.38</td>\n",
       "      <td>40.8</td>\n",
       "      <td>41.0</td>\n",
       "      <td>-0.11</td>\n",
       "      <td>-0.2683</td>\n",
       "      <td>0.11900000000000001</td>\n",
       "      <td>95205</td>\n",
       "      <td>3898690.75</td>\n",
       "      <td>13084800000.0</td>\n",
       "      <td>3271200000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9983</th>\n",
       "      <td>1998-08-21</td>\n",
       "      <td>'000858</td>\n",
       "      <td>五 粮 液</td>\n",
       "      <td>40.99</td>\n",
       "      <td>41.14</td>\n",
       "      <td>38.9</td>\n",
       "      <td>39.19</td>\n",
       "      <td>39.23</td>\n",
       "      <td>1.76</td>\n",
       "      <td>4.4864</td>\n",
       "      <td>1.3767</td>\n",
       "      <td>991200</td>\n",
       "      <td>39868897.34</td>\n",
       "      <td>13116800000.0</td>\n",
       "      <td>2951280000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9986</th>\n",
       "      <td>1998-08-18</td>\n",
       "      <td>'000858</td>\n",
       "      <td>五 粮 液</td>\n",
       "      <td>37.85</td>\n",
       "      <td>39.5</td>\n",
       "      <td>36.01</td>\n",
       "      <td>36.59</td>\n",
       "      <td>37.05</td>\n",
       "      <td>0.8</td>\n",
       "      <td>2.1592</td>\n",
       "      <td>1.2716</td>\n",
       "      <td>915534</td>\n",
       "      <td>34968100.88</td>\n",
       "      <td>12112000000.0</td>\n",
       "      <td>2725200000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10021</th>\n",
       "      <td>1998-06-30</td>\n",
       "      <td>'000858</td>\n",
       "      <td>五 粮 液</td>\n",
       "      <td>50.7</td>\n",
       "      <td>53.5</td>\n",
       "      <td>50.5</td>\n",
       "      <td>53.5</td>\n",
       "      <td>53.35</td>\n",
       "      <td>-2.65</td>\n",
       "      <td>-4.9672</td>\n",
       "      <td>1.2599</td>\n",
       "      <td>907130</td>\n",
       "      <td>47227032.08</td>\n",
       "      <td>16224000000.0</td>\n",
       "      <td>3650400000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10050</th>\n",
       "      <td>1998-05-20</td>\n",
       "      <td>'000858</td>\n",
       "      <td>五 粮 液</td>\n",
       "      <td>60.89</td>\n",
       "      <td>62.3</td>\n",
       "      <td>60.85</td>\n",
       "      <td>62.0</td>\n",
       "      <td>62.33</td>\n",
       "      <td>-1.44</td>\n",
       "      <td>-2.3103</td>\n",
       "      <td>1.2802</td>\n",
       "      <td>921740</td>\n",
       "      <td>56580399.29</td>\n",
       "      <td>19484800000.0</td>\n",
       "      <td>4384080000.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>268 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               日期     股票代码     名称     收盘价     最高价     最低价     开盘价     前收盘  \\\n",
       "337    2019-05-09  '600519   贵州茅台  858.81  879.87   842.5   875.0   884.4   \n",
       "362    2019-03-29  '600519   贵州茅台  853.99  866.68  830.17   835.0   806.8   \n",
       "461    2018-11-01  '600519   贵州茅台   563.0   585.5  551.25   555.0   548.9   \n",
       "462    2018-10-31  '600519   贵州茅台   548.9   555.0   522.0   527.0   524.0   \n",
       "476    2018-10-11  '600519   贵州茅台  644.99  668.94  635.01  635.01  670.92   \n",
       "...           ...      ...    ...     ...     ...     ...     ...     ...   \n",
       "9899   1998-12-21  '000858  五 粮 液   40.89   41.37   40.38    40.8    41.0   \n",
       "9983   1998-08-21  '000858  五 粮 液   40.99   41.14    38.9   39.19   39.23   \n",
       "9986   1998-08-18  '000858  五 粮 液   37.85    39.5   36.01   36.59   37.05   \n",
       "10021  1998-06-30  '000858  五 粮 液    50.7    53.5    50.5    53.5   53.35   \n",
       "10050  1998-05-20  '000858  五 粮 液   60.89    62.3   60.85    62.0   62.33   \n",
       "\n",
       "          涨跌额      涨跌幅                  换手率      成交量          成交金额  \\\n",
       "337    -25.59  -2.8935               0.7287  9154515  7863312116.0   \n",
       "362     47.19    5.849               0.7239  9093396  7702154797.0   \n",
       "461      14.1   2.5688   0.7809999999999999  9810672  5581027253.0   \n",
       "462      24.9   4.7519               0.7713  9688482  5239853122.0   \n",
       "476    -25.93  -3.8648   0.7290000000000001  9158196  5953169079.0   \n",
       "...       ...      ...                  ...      ...           ...   \n",
       "9899    -0.11  -0.2683  0.11900000000000001    95205    3898690.75   \n",
       "9983     1.76   4.4864               1.3767   991200   39868897.34   \n",
       "9986      0.8   2.1592               1.2716   915534   34968100.88   \n",
       "10021   -2.65  -4.9672               1.2599   907130   47227032.08   \n",
       "10050   -1.44  -2.3103               1.2802   921740   56580399.29   \n",
       "\n",
       "                   总市值             流通市值  \n",
       "337    1078835232620.0  1078835232620.0  \n",
       "362    1072780359220.0  1072780359220.0  \n",
       "461     707239361400.0   707239361400.0  \n",
       "462     689526972420.0   689526972420.0  \n",
       "476     810235019022.0   810235019022.0  \n",
       "...                ...              ...  \n",
       "9899     13084800000.0     3271200000.0  \n",
       "9983     13116800000.0     2951280000.0  \n",
       "9986     12112000000.0     2725200000.0  \n",
       "10021    16224000000.0     3650400000.0  \n",
       "10050    19484800000.0     4384080000.0  \n",
       "\n",
       "[268 rows x 15 columns]"
      ]
     },
     "execution_count": 84,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "flag = input()\n",
    "df[df['成交量']>flag]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "8902012\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>日期</th>\n",
       "      <th>股票代码</th>\n",
       "      <th>名称</th>\n",
       "      <th>收盘价</th>\n",
       "      <th>最高价</th>\n",
       "      <th>最低价</th>\n",
       "      <th>开盘价</th>\n",
       "      <th>前收盘</th>\n",
       "      <th>涨跌额</th>\n",
       "      <th>涨跌幅</th>\n",
       "      <th>换手率</th>\n",
       "      <th>成交量</th>\n",
       "      <th>成交金额</th>\n",
       "      <th>总市值</th>\n",
       "      <th>流通市值</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>2020-07-28</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>1670.0</td>\n",
       "      <td>1680.0</td>\n",
       "      <td>1630.0</td>\n",
       "      <td>1630.0</td>\n",
       "      <td>1622.55</td>\n",
       "      <td>47.45</td>\n",
       "      <td>2.9244</td>\n",
       "      <td>0.4371</td>\n",
       "      <td>5491152</td>\n",
       "      <td>9133721867.0</td>\n",
       "      <td>2097850326000.0</td>\n",
       "      <td>2097850326000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>2020-07-08</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>1681.34</td>\n",
       "      <td>1719.0</td>\n",
       "      <td>1660.0</td>\n",
       "      <td>1680.0</td>\n",
       "      <td>1688.0</td>\n",
       "      <td>-6.66</td>\n",
       "      <td>-0.3945</td>\n",
       "      <td>0.4233</td>\n",
       "      <td>5316998</td>\n",
       "      <td>8963189092.0</td>\n",
       "      <td>2112095609050.0</td>\n",
       "      <td>2112095609050.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>2019-11-29</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>1129.0</td>\n",
       "      <td>1165.5</td>\n",
       "      <td>1112.89</td>\n",
       "      <td>1165.5</td>\n",
       "      <td>1175.8</td>\n",
       "      <td>-46.8</td>\n",
       "      <td>-3.9803</td>\n",
       "      <td>0.6559</td>\n",
       "      <td>8239732</td>\n",
       "      <td>9338326554.0</td>\n",
       "      <td>1418247316200.0</td>\n",
       "      <td>1418247316200.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>249</th>\n",
       "      <td>2019-09-11</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>1069.52</td>\n",
       "      <td>1119.97</td>\n",
       "      <td>1068.0</td>\n",
       "      <td>1119.22</td>\n",
       "      <td>1123.85</td>\n",
       "      <td>-54.33</td>\n",
       "      <td>-4.8343</td>\n",
       "      <td>0.6505</td>\n",
       "      <td>8171654</td>\n",
       "      <td>8904690560.0</td>\n",
       "      <td>1343528671060.0</td>\n",
       "      <td>1343528671060.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>339</th>\n",
       "      <td>2019-05-07</td>\n",
       "      <td>'600519</td>\n",
       "      <td>贵州茅台</td>\n",
       "      <td>890.0</td>\n",
       "      <td>913.94</td>\n",
       "      <td>870.22</td>\n",
       "      <td>893.28</td>\n",
       "      <td>906.0</td>\n",
       "      <td>-16.0</td>\n",
       "      <td>-1.766</td>\n",
       "      <td>0.8027</td>\n",
       "      <td>10083726</td>\n",
       "      <td>9045117765.0</td>\n",
       "      <td>1118016042000.0</td>\n",
       "      <td>1118016042000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9936</th>\n",
       "      <td>1998-10-29</td>\n",
       "      <td>'000858</td>\n",
       "      <td>五 粮 液</td>\n",
       "      <td>38.91</td>\n",
       "      <td>39.43</td>\n",
       "      <td>38.68</td>\n",
       "      <td>39.0</td>\n",
       "      <td>38.94</td>\n",
       "      <td>-0.03</td>\n",
       "      <td>-0.077</td>\n",
       "      <td>0.2905</td>\n",
       "      <td>232365</td>\n",
       "      <td>9042487.75</td>\n",
       "      <td>12451200000.0</td>\n",
       "      <td>3112800000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9943</th>\n",
       "      <td>1998-10-20</td>\n",
       "      <td>'000858</td>\n",
       "      <td>五 粮 液</td>\n",
       "      <td>40.0</td>\n",
       "      <td>40.55</td>\n",
       "      <td>39.99</td>\n",
       "      <td>40.32</td>\n",
       "      <td>40.3</td>\n",
       "      <td>-0.3</td>\n",
       "      <td>-0.7444</td>\n",
       "      <td>0.3357</td>\n",
       "      <td>241700</td>\n",
       "      <td>9704480.8</td>\n",
       "      <td>12800000000.0</td>\n",
       "      <td>2880000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9950</th>\n",
       "      <td>1998-10-09</td>\n",
       "      <td>'000858</td>\n",
       "      <td>五 粮 液</td>\n",
       "      <td>40.78</td>\n",
       "      <td>41.3</td>\n",
       "      <td>40.7</td>\n",
       "      <td>41.0</td>\n",
       "      <td>40.7</td>\n",
       "      <td>0.08</td>\n",
       "      <td>0.1966</td>\n",
       "      <td>0.3044</td>\n",
       "      <td>219182</td>\n",
       "      <td>8988578.86</td>\n",
       "      <td>13049600000.0</td>\n",
       "      <td>2936160000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9958</th>\n",
       "      <td>1998-09-25</td>\n",
       "      <td>'000858</td>\n",
       "      <td>五 粮 液</td>\n",
       "      <td>40.4</td>\n",
       "      <td>40.5</td>\n",
       "      <td>39.88</td>\n",
       "      <td>39.9</td>\n",
       "      <td>39.88</td>\n",
       "      <td>0.52</td>\n",
       "      <td>1.3039</td>\n",
       "      <td>0.3248</td>\n",
       "      <td>233853</td>\n",
       "      <td>9373225.19</td>\n",
       "      <td>12928000000.0</td>\n",
       "      <td>2908800000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10055</th>\n",
       "      <td>1998-05-13</td>\n",
       "      <td>'000858</td>\n",
       "      <td>五 粮 液</td>\n",
       "      <td>63.85</td>\n",
       "      <td>65.75</td>\n",
       "      <td>63.01</td>\n",
       "      <td>63.2</td>\n",
       "      <td>63.43</td>\n",
       "      <td>0.42</td>\n",
       "      <td>0.6621</td>\n",
       "      <td>1.9348</td>\n",
       "      <td>1393048</td>\n",
       "      <td>89469272.65</td>\n",
       "      <td>20432000000.0</td>\n",
       "      <td>4597200000.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>460 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               日期     股票代码     名称      收盘价      最高价      最低价      开盘价  \\\n",
       "39     2020-07-28  '600519   贵州茅台   1670.0   1680.0   1630.0   1630.0   \n",
       "53     2020-07-08  '600519   贵州茅台  1681.34   1719.0   1660.0   1680.0   \n",
       "198    2019-11-29  '600519   贵州茅台   1129.0   1165.5  1112.89   1165.5   \n",
       "249    2019-09-11  '600519   贵州茅台  1069.52  1119.97   1068.0  1119.22   \n",
       "339    2019-05-07  '600519   贵州茅台    890.0   913.94   870.22   893.28   \n",
       "...           ...      ...    ...      ...      ...      ...      ...   \n",
       "9936   1998-10-29  '000858  五 粮 液    38.91    39.43    38.68     39.0   \n",
       "9943   1998-10-20  '000858  五 粮 液     40.0    40.55    39.99    40.32   \n",
       "9950   1998-10-09  '000858  五 粮 液    40.78     41.3     40.7     41.0   \n",
       "9958   1998-09-25  '000858  五 粮 液     40.4     40.5    39.88     39.9   \n",
       "10055  1998-05-13  '000858  五 粮 液    63.85    65.75    63.01     63.2   \n",
       "\n",
       "           前收盘     涨跌额      涨跌幅     换手率       成交量          成交金额  \\\n",
       "39     1622.55   47.45   2.9244  0.4371   5491152  9133721867.0   \n",
       "53      1688.0   -6.66  -0.3945  0.4233   5316998  8963189092.0   \n",
       "198     1175.8   -46.8  -3.9803  0.6559   8239732  9338326554.0   \n",
       "249    1123.85  -54.33  -4.8343  0.6505   8171654  8904690560.0   \n",
       "339      906.0   -16.0   -1.766  0.8027  10083726  9045117765.0   \n",
       "...        ...     ...      ...     ...       ...           ...   \n",
       "9936     38.94   -0.03   -0.077  0.2905    232365    9042487.75   \n",
       "9943      40.3    -0.3  -0.7444  0.3357    241700     9704480.8   \n",
       "9950      40.7    0.08   0.1966  0.3044    219182    8988578.86   \n",
       "9958     39.88    0.52   1.3039  0.3248    233853    9373225.19   \n",
       "10055    63.43    0.42   0.6621  1.9348   1393048   89469272.65   \n",
       "\n",
       "                   总市值             流通市值  \n",
       "39     2097850326000.0  2097850326000.0  \n",
       "53     2112095609050.0  2112095609050.0  \n",
       "198    1418247316200.0  1418247316200.0  \n",
       "249    1343528671060.0  1343528671060.0  \n",
       "339    1118016042000.0  1118016042000.0  \n",
       "...                ...              ...  \n",
       "9936     12451200000.0     3112800000.0  \n",
       "9943     12800000000.0     2880000000.0  \n",
       "9950     13049600000.0     2936160000.0  \n",
       "9958     12928000000.0     2908800000.0  \n",
       "10055    20432000000.0     4597200000.0  \n",
       "\n",
       "[460 rows x 15 columns]"
      ]
     },
     "execution_count": 87,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "flag = (input())\n",
    "df[df['成交金额']>flag]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
